[RESOLVED] Query error

mikawhat

I'm running a query in phpMyAdmin and it works, however when i use the query in my php code i get an error message.
The query is:

SELECT category.id, category.name, LEFT(category.contents, 400), category.image FROM maincat, maincatcategory, category WHERE maincatcategory.maincatid=maincat.id AND maincatcategory.categoryid=category.id AND maincat.id='$id' ORDER BY category.corder

The error message is:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #10'

paulnaj

Hi,

Just while debugging, echo out the value of $id just before using the above query (which looks OK to me).

cgraz

I agree that the problem likely is not with your query (assuming all of the field names are correct).

Post the relevant code and I'm sure someone can point out what's going wrong.

Sxooter

This:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #10'

tells me you are passing a resource id into your mysql_query function. I.e. something like:

$id = mysql_connect(...
$query = "select ... from ... where id=$id";
$res = mysql_query($query);

See the problem there?

mikawhat

This is my code:

$id = $_GET['id'];
	$query = "SELECT category.id, category.name, LEFT(category.contents, 400), category.image FROM maincat, maincatcategory, category WHERE maincatcategory.maincatid=maincat.id AND maincatcategory.categoryid=category.id AND maincat.id='$id' ORDER BY category.corder";	
	$query_result = @mysql_query ($query);
if (!mysql_query($query_result)) {
	echo "Error: " . mysql_error() . ".";
}[/QUOTE]
The error message is:

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #10' at line 1.SUB 1~

SUB 1~ is the content of category.name

ClarkF1

That's running the query twice, the second time using the result of the first query which won't work as the result doesn't contain valid query syntax because it's not a query

Instead of

$query_result = @mysql_query ($query);
if (!mysql_query($query_result)) {
echo "Error: " . mysql_error() . ".";
}

use

$query_result = mysql_query ($query) or die('Error: ' . mysql_error());

mikawhat

OK now it's working. Can you explain why is running the query twice? Thanks

ClarkF1

If you look at this snippet of your original code

$query_result = @mysql_query ($query);
if (!mysql_query($query_result)) {
echo "Error: " . mysql_error() . ".";
}

You have used mysql_query twice.

As your problem has been fixed, please mark this thread resolved.

mikawhat

OK. Thanks to everyone for helping.