MySQL Forums
Forum List  »  PHP

Re: mysql_num_rows(): supplied argument is not a valid MySQL result
Posted by: stef an
Date: May 16, 2012 05:50PM

this topic was posted in the Newbie section as I am new to MySQL, for that matter I'm not sure what you mean by:

Where is the error check after the mysql_query() call?
For that matter, where is the connect call?

regarding commandline msyql, this is what i've got:
Showing rows 0 - 7 ( 8 total, Query took 0.0260 sec)

SELECT s.name AS song_name, s.url AS song_url, s.submit_name, s.submit_time, a.name AS artist_name, a.url AS artist_url
FROM song AS s, artist AS a
WHERE s.artist_id = a.id
ORDER BY s.id DESC
LIMIT 20

and in the table below that, I get a list of song_name, song_url, submit_name, submit_time, artist_name, artist_url

if you want to see the table, i've uploaded a picture of the screen below:
http://i1208.photobucket.com/albums/cc364/f4n3/mysql-1.png

Options: ReplyQuote


Subject
Written By
Posted
Re: mysql_num_rows(): supplied argument is not a valid MySQL result
May 16, 2012 05:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.