Hello,
What is the best way to accomplish the following?:
Connect to MySQL database
Execute a query
Fetch a row from that query (mysql_fetch_array)
Based on the data from the original query, generate a second query
Execute the second query
Fetch a row from the second query (mysql_fetch_array)
Fetch another row from the first query (mysql_fetch_array)
Based on the data from the original query, generate a second query
Execute the second query
Fetch a row from the second query (mysql_fetch_array)
...etc, until I have processed all the rows in the original query.
I am attempting to do this, and keep getting
"Supplied argument is not a valid MySQL result resource in ..... on line 52"
Line 52 is the line where I fetch the row from the second query.
Is there a rule I am violating? I've read the manual, searched online databases,
etc etc and I don't find anything. I've done this with other SQL databases and PHP,
is there something special about MySQL that I am not aware of?
Thanks
Dan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
