Quick problem

miseria · 09-12-2005, 09:37 AM

Hey, Can anybody tell me what's wrong with the following? I'd be very grateful

PHP Code:

  $query = mysql_query("SELECT * FROM FORUM_users WHERE username='$sessionusername'");

$sql = mysql_query($query) or die(mysql_error());

    $obj = mysql_fetch_object($sql);

    $postcount = $obj->user_posts; 

 
echo "$postcount";

Returns

PHP Code:

  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 #5' at line 1

dgaussin · 09-12-2005, 09:55 AM

I think it's because $sessionusername contains 'Resource id #5' and # should be escaped. Anyway I'm not sure it's normal you have $sessionusernam set to that... Try to display the value before execute the query...

miseria · 09-12-2005, 10:08 AM

Thanks for the reply. I have retyped te code in the following way where $username is the username for the session:

PHP Code:

  $query = mysql_query("SELECT * FROM FORUM_users WHERE username='$username'");

$result=mysql_query($query);

$num=mysql_num_rows($result);

 
$i=0;

while ($i < $num) {

 
$posts=mysql_result($result,$i,"user_posts");

 
$i++;

}

 
echo "$posts";

This returns

PHP Code:

  Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/darkfx.co.uk/httpdocs/studios/test.php on line 13

moondog · 09-12-2005, 10:51 AM

I think the problem is that you are trying to execute the query twice.

PHP Code:

   $query = mysql_query("SELECT * FROM FORUM_users WHERE username='$username'");

The above line actually takes the sql statement, executes it, and assigns the result to $query. In the next line:

PHP Code:

  $result=mysql_query($query);

You try to do a query again, but this time, you are using the variable $query, which is already a result set from the previous line.

I think the solution might be obvious now. This should work:

PHP Code:

   
$query = "SELECT * FROM FORUM_users WHERE username='$username'";

 
$result=mysql_query($query);

Happy coding.

-Bob

miseria · 09-12-2005, 11:46 AM

This man, he is a legend. I thank you so much

moondog · 09-12-2005, 01:56 PM

Quote:

Originally Posted by miseria

This man, he is a legend. I thank you so much

HAHA!

09-12-2005, 09:37 AM	#1 (permalink)
miseria SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 545 205.50 NP$ (Donate)	Quick problem Hey, Can anybody tell me what's wrong with the following? I'd be very grateful PHP Code: `$query = mysql_query("SELECT * FROM FORUM_users WHERE username='$sessionusername'"); $sql = mysql_query($query) or die(mysql_error()); $obj = mysql_fetch_object($sql); $postcount = $obj->user_posts; echo "$postcount";` Returns PHP Code: `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 #5' at line 1`

09-12-2005, 10:08 AM	#3 (permalink)
miseria SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 545 205.50 NP$ (Donate)	Thanks for the reply. I have retyped te code in the following way where $username is the username for the session: PHP Code: `$query = mysql_query("SELECT * FROM FORUM_users WHERE username='$username'"); $result=mysql_query($query); $num=mysql_num_rows($result); $i=0; while ($i < $num) { $posts=mysql_result($result,$i,"user_posts"); $i++; } echo "$posts";` This returns PHP Code: `Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/darkfx.co.uk/httpdocs/studios/test.php on line 13` Last edited by miseria; 09-12-2005 at 10:12 AM.

09-12-2005, 10:51 AM	#4 (permalink)
moondog NamePros Regular Join Date: Jun 2004 Posts: 476 3,677.00 NP$ (Donate)	I think the problem is that you are trying to execute the query twice. PHP Code: `$query = mysql_query("SELECT * FROM FORUM_users WHERE username='$username'");` The above line actually takes the sql statement, executes it, and assigns the result to $query. In the next line: PHP Code: `$result=mysql_query($query);` You try to do a query again, but this time, you are using the variable $query, which is already a result set from the previous line. I think the solution might be obvious now. This should work: PHP Code: `$query = "SELECT * FROM FORUM_users WHERE username='$username'"; $result=mysql_query($query);` Happy coding. -Bob __________________ The mass purge has begun.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Very wierd Windows problem	Ravi_s	Web Design Discussion	0	08-12-2005 10:29 PM
Problem at godaddy or others not as quick???	quality	Domain Name Discussion	3	08-04-2005 07:52 PM
MySQL or PHP problem	Wildchild22	Website Development	10	07-14-2005 05:24 AM
vBulletin Problem!!!!!!!!!!!!	domaino	Programming	11	06-23-2005 06:29 AM

09-12-2005, 09:55 AM	#2 (permalink)
dgaussin Senior Member Join Date: May 2004 Location: France Posts: 1,294 85.60 NP$ (Donate)	I think it's because $sessionusername contains 'Resource id #5' and # should be escaped. Anyway I'm not sure it's normal you have $sessionusernam set to that... Try to display the value before execute the query...

09-12-2005, 11:46 AM	#5 (permalink)
miseria SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 545 205.50 NP$ (Donate)	This man, he is a legend. I thank you so much

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)