[RESOLVED] What am I missing with this simple query?

[rsmith]

Hey all. Maybe it's just sleep deprivation but I'm getting this error...

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/helpdesk/admin/login.php on line 10

and here's the query:

		$login_query = "SELECT * FROM `staff` WHERE `username` = '".$username."'";
		$login_query_result = mysql_query($login_query);

	$info = mysql_fetch_assoc($login_query_result); //this is line 10

Using PHP on Apache 2 running on Ubuntu Server

[paulnaj]

'... boolean given... ' means that mysql_query() returned false, so maybe something is wrong with the SQL.

P

[rsmith]

Thanks for the extra set of eyes. I was convinced it was a PHP issue. Turned out I fat-fingered the SQL connection parameters in my include file. Thanks! Now to get some much needed sleep. 😃