[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