punctuation problem with MySQL query

[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!

[Barand]

This should work

 

[php:1:e0b3a37a3c]<?php

$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);

?>[/php:1:e0b3a37a3c]

[drew69]

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