BetterPHP

I keep getting this error when viewing the user_list.php file:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a8913488/public_html/core/inc/user.inc.php on line 13

and it says this at the very bottom left:

Array()

here is the page live:

awsomechat.comuv.com/user_list.php.

Here is my code:

<?php
//user.inc.php file
session_start();

// SQL stuff.
mysql_connect('mysql_host','username','password');
mysql_select_db('database');

// Get users from table
function fetch_users() {
$result = mysql_query('SELECT `user_id` AS `id`, `user_name` AS `username` FROM users');
$users = array();
while(($row = mysql_fetch_assoc($result)) !== false) {
    $users[] = $row;
}
return $users;
}
?>

I would be glad if someone helped.

Fix this line

while(($row = mysql_fetch_assoc($result)) !== false) {

Still getting this error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a8913488/public_html/core/inc/user.inc.php on line 13

Djmann1013 wrote:How do I fix it?

while($row = mysql_fetch_assoc($result))

also you may use fetch_array

I am still getting the error.

Djmann1013 wrote:I am still getting the error.

past the code after edit..

That error means something went wrong with your SQL query. Adding

echo mysql_error();

under the failing query will provide a more detailed description of the error.

function fetch_users() {
$result = mysql_query('SELECT `user_id` AS `id`, `user_name` AS `username` FROM users');

echo mysql_error();

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

It works. Thanks.