[RESOLVED] Newbie to MySQL--- Query error: Query was empty???

Tylor_Famous

OK I am new to this all so bare with me as I try to explain it all!

I am following along with a lesson by Cartoonsmart.com and I am making a form that will add information to the database and display it with flash. Submitting went good but I am having trouble with displaying.

I am getting the message:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /..../..../..../...return_Database_Info.php on line 9
&Totalnumber_of_entries=&Query error: Query was empty

Here is my code. I am obviously missing my log in information but besides that, it is my entire code.

<?php 
$qResult = mysql_query ("SELECT * FROM commentbook ORDER BY id DESC");

$nRows = mysql_num_rows($qResult);
$rString ="&Totalnumber_of_entries=".$nRows;


for ($i=0; $i< $nRows; $i++){
	$row = mysql_fetch_array($qResult);
	$rString .=
	"&id".$i."=".$row['id'].
	"&visitor".$i."=".$row['visitor'].
	"&email".$i."=".$row['email']. 
	"&item".$i."=".$row['item']. 
	"&comment".$i."=".$row['comment']. 
	"&time".$i."=".$row['time'];
	mysql_query($rString) or die(mysql_error());
}
echo $rString."&";

$result = mysql_query ($query) 
  or die("Query error: ". mysql_error());

?>

Please help me 🙁

stolzyboy

change this line:

$qResult = mysql_query ("SELECT * FROM commentbook ORDER BY id DESC");

to this:

$qResult = mysql_query ("SELECT * FROM commentbook ORDER BY id DESC") or die(mysql_error());

This will see if your query is in fact working correctly. If it is, we can move on to other things.

Tylor_Famous

stolzyboy wrote:
change this line:
$qResult = mysql_query ("SELECT * FROM commentbook ORDER BY id DESC"); 
to this:
$qResult = mysql_query ("SELECT * FROM commentbook ORDER BY id DESC") or die(mysql_error()); 
This will see if your query is in fact working correctly. If it is, we can move on to other things.

Thanks for such a fast reply! Once I made the changes you suggested I noticed the problem (I had entered the wrong name for the table). So I fixed that and tested it again, only to get a new 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 '&Total number_of_entries=3&id0=4&visitor0=Tylor Skory&email0=Tylor_Famous@yahoo.c' at line 1

This is strange because is starts to list what is in the database but cuts it off or something? Any ideas why?

bradgrafelman

What exactly are you trying to do? You're definitely not producing syntax that MySQL is ever going to recognize...

Tylor_Famous

bradgrafelman wrote:
What exactly are you trying to do? You're definitely not producing syntax that MySQL is ever going to recognize...

I am following along with a lesson and I am trying to produce something that FLASH will be able to recognize.

bradgrafelman

That's what I thought; that definitely looks like a string that a browser or Flash application might understand, but why are you trying to execute that string as a MySQL query inside your for() loop??

stolzyboy

Ack, Flash/PHP integration, fun stuff there.

I don't think you'd want to run a query on the string you are trying to send to FLASH.

Brad, maybe you know, but to get variables to/from flash, you send query_string type string to flash and grab the variables that way. It's really cumbersome at times.

bradgrafelman

stolzyboy wrote:
Brad, maybe you know, but to get variables to/from flash, you send query_string type string to flash and grab the variables that way. It's really cumbersome at times.

I think we're both replying at the same time. :p

stolzyboy

Seems so! 🙂

Tylor_Famous

So far it seems like I ALMOST have it. At this point I was supposed to have a long string of text (something along the lines of "&Totalnumber_of_entries=3&id0=4&visitor0=Tylor Skory&email0=...")

It starts to do that but stops half way through (I have no idea why that would be). It just stops writing it or something.

If I can just get it to spit out that long string of text then I think I will be all good.

Right now it only spits this out.

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 '&Totalnumber_of_entries=3&id0=4&visitor0=Tylor Skory&email0=Tylor_Famous@yahoo.c' at line 1

bradgrafelman

Again, why are you taking this string of data that you're going to pass to your Flash application and executing it as a MySQL query? MySQL can't understand Flash's method of reading data, and even if it could... there's no point in sending the data you just received back to the DB in a query.

Remove the mysql_query() call inside the for() loop, and remove the 2 lines below the echo() statement where you call mysql_query() again.

Tylor_Famous

bradgrafelman wrote:
Again, why are you taking this string of data that you're going to pass to your Flash application and executing it as a MySQL query? MySQL can't understand Flash's method of reading data, and even if it could... there's no point in sending the data you just received back to the DB in a query.

Remove the mysql_query() call inside the for() loop, and remove the 2 lines below the echo() statement where you call mysql_query() again.

I honestly don't know. I am simply following along with a lesson and must have messed up somewhere. I didn't write the lesson I am just following it.

Tylor_Famous

OK from just fooling around I got it to work! Thanks for your time guys!