Help with academic project PHP AJAX MySQL HTML5

CreaDigi · April 30th, 2012, 08:14 AM

Hi,

I am trying to access a database using the a html 5 select field for a mobile app for college. I have been trying to use the w3schools tutorial found here:
http://www.w3schools.com/php/php_ajax_database.asp

I have essentially copied the tutorial exactly but I keep getting the error:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\ajax\getuser.php on line 25

I cant actually reproduce the tutorial without errors which is very frustrating as I need to be able to get this to work within a html 5 phonegap app. Any help would be greatly appreciated.

Many thanks

UseLess · April 30th, 2012, 09:14 AM

Greetings,

There is no error handling around this line;

Code:

$result = mysql_query($sql);

so because the query is failing it's returning FALSE instead of a resource.

CreaDigi · April 30th, 2012, 10:19 AM

Please forgive my ignorance but I do not understand how to do this?

UseLess · May 1st, 2012, 08:35 AM

Greetings,

Code:

if( !$result = mysql_query($sql) )
{
	die('There was a problem executing the query, MySQL returned:<br />Error Number: ' . mysql_errno() . '<br />Error: ' . mysql_error());
}