correct syntax??

[m00nz00mer]

Hey im having some problems with this piece of code, can someone tell me why this isnt working.

 

Cheers.

 

<?php

 

$titleQuery = mysql_query("SELECT catDesc FROM tablename WHERE catID='".$_GET['categoryID']."'");

$titleQueryResult = mysql_query($titleQuery);

$title = mysql_result($titleQueryResult, 0);

 

echo $title;

 

?>

 

Error is...

 

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/numyspace.co.uk/web_users/home/~unn_p185724/public_html/categories.php on line 84

 

line 84 is: $titleQueryResult = mysql_query($titleQuery);

 

Cheers.

 

 

[rhodesa]

You are executing mysql_query() twice. Remove the mysql_query from the first line.

[m00nz00mer]

just changed it to...

 

$titleQuery = ("SELECT catDesc FROM tablename WHERE catID='".$_GET['categoryID']."'");

$titleQueryResult = mysql_query($titleQuery);

$title = mysql_result($titleQueryResult, 0);

 

but im still getting the same error.

[rhodesa]

change it to this and let us know what it says:

 

 

$titleQuery = "SELECT catDesc FROM tablename WHERE catID='".$_GET['categoryID']."'";
$titleQueryResult = mysql_query($titleQuery) or die("Query error: ".mysql_error());
$title = mysql_result($titleQueryResult, 0);

[m00nz00mer]

hah, table didnt exist... silly me, thanks for you help