[Resolved] Keep getting a mysql error

[speedphreak]

Not sure what is causing this. I created a test page to show the number of rows returned in the query, and I get a similar error. Here is the error from the test page followed by the code.

You have an error in your SQL syntax near 'Resource id #2' at line 1

<?
mysql_connect("localhost", "$user", "$pass");
mysql_select_db("support");
$query = mysql_query("SELECT * FROM ticket_attachments");
$result = mysql_query($query) or die (mysql_error());
$num_results = mysql_num_rows($result);

echo $num_results;
?>

[speedphreak]

I added a WHERE clause to the code to see if that helped, but no dice.

<?
mysql_connect("localhost", "root", "7982ncxz");
mysql_select_db("support");
$query = mysql_query("SELECT * FROM ticket_attachments WHERE ref='12'");
$result = mysql_query($query) or die (mysql_error());
$num_results = mysql_num_rows($result);

echo $num_results;
?>

That produced the same error.

Here's a screen shot to show that those records do exist. 😉

[stolzyboy]

<? 
$conn = mysql_connect("localhost", "root", "7982ncxz"); 
$db = mysql_select_db("support"); 
$query = "SELECT * FROM ticket_attachments WHERE ref='12';"; 
$result = mysql_query($query) or die (mysql_error()); 
$num_results = mysql_num_rows($result); 
echo $num_results; 
?>

[speedphreak]

Just realized that I was executing that query twice in a row. Man, I'm a moron. Thanks for the kick in the head.