[thelist] php/mySQL update problem
rudy
rudy937 at rogers.com
Sat Aug 23 20:27:05 CDT 2003
your queries look fine except for the quotes around $aid
it's numeric, right? i'm guessing, but these ids usually are
i absolutely hate the way mysql lets you get away with sloppy coding like
WHERE articleid = '$aid'
this should give a syntax error if articleid is numeric
the update is probably running, but not updating any row, because it can't
find the right row with that WHERE clause
then the select runs, and it can't find the row either
rudy
More information about the thelist
mailing list