What does this error mean?

[KDM]

I'm following a members page tutorial. I have everything copied just like he does but I keep getting this error.

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/13/6987913/html/tutorials/user_profiles/core/inc/user.inc.php on line 8

 

Code

 

<?php
// fetches all of the users from the table
function fetch_users(){
$result = mysql_query('SELECT `user_id` AS `id`, `user_username` AS `username` FROM `users`');	

$users = array();

while (($row = mysql_fetch_assoc($result)) !== false){
	$users[] = $row;

}

return $users;
}

?>

[TeNDoLLA]

It means your mysql result set is not valid, which leads to that your mysql query fails. Try adding mysql_error in your query and see what error it is giving.

 

$result = mysql_query('SELECT `user_id` AS `id`, `user_username` AS `username` FROM `users`') or die(mysql_error());

[KDM]

It means your mysql result set is not valid, which leads to that your mysql query fails. Try adding mysql_error in your query and see what error it is giving.

 

$result = mysql_query('SELECT `user_id` AS `id`, `user_username` AS `username` FROM `users`') or die(mysql_error());

 

Ok wow thanks I see the problem

 

Unknown column 'user_username' in 'field list'