Another thought is to trap for errors in the mysql_query statement, since whatever it's generating isn't being interpreted as an acceptable result set by the server. Bruce Smith
________________________________ From: asgallant <[email protected]> To: [email protected] Cc: Bruce Smith <[email protected]> Sent: Monday, August 29, 2011 10:06 AM Subject: Re: [visualization-api] Re: line chart from mysql example Since you are getting an error related to the mysql_num_rows() function, it seems likely that the problem is either in your SQL itself or the code you are using to connect to the database. Try using a simple query (like "SELECT * from date") and see if that returns anything. If not, then the problem is probably in your connection code (the missing "$" in front of "database_name" seems a probable cause, but as BruceS mentioned, I would think that would trip the "or die" clause). If the simple select works, then try your select statement from the MySQL command line or your database interface (something like PHPMyAdmin) and see what it returns. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
