NYCPHP Meetup

[nycphp-talk] Is there something wrong with this SQL query in PHP?

Anthony Wlodarski aw at sap8.com
Tue Aug 14 16:24:37 EDT 2007


TADA!  We have a winner!

The function was bogging down on the second parameter.  I think I copied the
code from an earlier project and forgot to check the function syntax and now
the echo statement is returning a 1 so we know it is right on now (also made
changes in the main application and it is correctly working).  Some things I
will work on in regards to future development are this SQL injection and
correct checking before the query is ran.

Thanks everyone!

Anthony Wlodarski
Senior Technical Recruiter
Shulman Fleming & Partners
646-285-0500 x230
aw at sap8.com


-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of Carlos A Hoyos
Sent: Tuesday, August 14, 2007 4:08 PM
To: NYPHP Talk
Subject: RE: [nycphp-talk] Is there something wrong with this SQL query in
PHP?


In case this wasn't clear...
> On quick inspection, function mysql_fetch_assoc only takes one
parameter...
> this might be a problem. mysql_fetch_assoc

Try Removing the second parameter from function mysql_fetch_assoc, i.e.
take out the MYSQL_ASSOC to read $row = mysql_fetch_assoc($result);

Carlos Hoyos

_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com

Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php





More information about the talk mailing list