PHP/MySQL noob rides again.. into trouble
| From: | Paul Jinks | Date: | Fri, 16 Dec 2005 12:30:01 +0000 |
| Subject: | PHP/MySQL noob rides again.. into trouble | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-227527@lists.php.net to get a copy of this message | ||
Hi all,
I have a site where users can search study projects. I'd like to be able to clicks on a project title which passes a variable to this page, which then displays all the data on that project in a table. Cool - and to a noob like me, actually pretty exciting. Except it doesn't work.
I get a "couldn't set value of result" message - see end of code. The page displayed all the projects fine when I messed up passing them from the previous page, so the problem is presumably in the first SQL query. Any suggestions?
<?
$connect = mysql_connect("", "", "")
or die("could not connect");
$db = mysql_select_db("")
or die("could not select db");
if (isset($HTTP_GET_VARS['projTitle']))
{
$SQLQuery = "SELECT * FROM project WHERE
projTitle = ".$HTTP_GET_VARS['projTitle']
or die("SQLQuery 1 failed");
}
else
{
$SQLQuery = "SELECT*FROM project ORDER BY projTitle"
or die("SQLQuery 2 failed");
}
$result = mysql_query($SQLQuery,$connect)
or die("couldn't set value of result");
?>
TIA
Paul