drew69
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by drew69
-
-
Why do I keep getting this error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home.......
I have tried surrounding the variables with nothing, \'\" & & \"\', \'& &\', \' \', etc.....
<?
$stryes=\"yes\";
$strwaitno=\"no\";
$sqlind = mysql_query(\"SELECT * FROM resevents WHERE eventnum=\'& $eventnumqs &\' AND show= \'& $stryes &\' AND waitlisted= \'& $strwaitno &\' ORDER BY memlastname\",$dbh);
$rs=mysql_fetch_array($sqlind);
?>
any help would be appreciated!
punctuation problem with MySQL query
in MySQL Help
Posted
I appreciate the help, I just got it running not too long ago.
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....
Thanks again