RE: [PHP] MySQL error
| From: | Jason Murray | Date: | Tue, 10 Oct 2000 02:16:12 +0000 |
| Subject: | RE: [PHP] MySQL error | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-19276@lists.php.net to get a copy of this message | ||
> OOPS! I left out part of that code snipet. Here it is again:
>
> $db = mysql_connect("localhost","user","pass");
> mysql_select_db("database_name",$db);
> $query="SELECT * FROM games WHERE
> genre=$gameone_genre&number=$gameone_number";
> $info=mysql_query($query,$db);
> $row=mysql_fetch_row($info);
Try an actual SQL query :)
SELECT * FROM games WHERE genre=$gameone_genre AND number=$gameone_number;
If they're text fields, use '' around them.
Jason