punctuation problem with MySQL query
Posted 04 November 2003 - 04:52 PM
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home.......
I have tried surrounding the variables with nothing, \'\" & & \"\', \'& &\', \' \', etc.....
$sqlind = mysql_query(\"SELECT * FROM resevents WHERE eventnum=\'& $eventnumqs &\' AND show= \'& $stryes &\' AND waitlisted= \'& $strwaitno &\' ORDER BY memlastname\",$dbh);
any help would be appreciated!
Posted 04 November 2003 - 08:38 PM
$sqlind = mysql_query(\"SELECT * FROM resevents WHERE eventnum=$eventnumqs AND show= \'$stryes\' AND waitlisted= \'$strwaitno\' ORDER BY memlastname\",$dbh);
Donations gratefully received
|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
Posted 04 November 2003 - 10:16 PM
Oddly enough, it was having a field named \"show\" that screwed it all up. It thought I was trying to put in another command when it got to that field name.
Weird. It worked under ASP with the field \"show\", but not PHP....
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users