Error : mysql_fetch_assoc ( Table Field Name )

Question

everything was working fine , suddenly this happened :

PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in G:\PleskVhosts\modelcharm.com\httpdocs\core\functions\users.php on line 17

function user_data($user_id) {
    $data = array();
    $user_id = (int)$user_id;

    $func_num_args = func_num_args();
    $func_get_args = func_get_args();

    if ($func_num_args > 1) {
        unset($func_get_args[0]);   

        $fields = '`' . implode('`, `', $func_get_args) . '`';
        $data = mysql_fetch_assoc(mysql_query("SELECT $fields FROM `users` WHERE `user_id` = $user_id"));

        return $data;
    }}

Anything wrong in the code ?

yes probably `$func_get_args` is empty. thus fieldlist is empty. thus mysql has syntax error. you can have a better understanding of what is happening by adding `echo mysql_error()` — Volkan Ulukut, Feb 19 '14 at 09:52
Many things. You don't check whether the query is successful or not for start. You use outdated mysql_* functions as well. — N.B., Feb 19 '14 at 09:52

Christoph Bühler · Accepted Answer · 2014-02-19T09:57:34.910

5

It means, that there was an error. This will show you a detailed error message:

$getData = mysql_query("SELECT $fields FROM `users` WHERE `user_id` = $user_id") or die (mysql_error());

$data = mysql_fetch_assoc($getData);

edited Feb 19 '14 at 09:57

answered Feb 19 '14 at 09:53

Christoph Bühler

2,617
1
25
41

2

Thanks , this helped me .. i changed a field name in database and didn't change it in init.php file ... that was helpful – Eng-Amir Feb 19 '14 at 10:25

score 0 · Answer 2 · edited May 22 '14 at 20:04

First of all avoid using mysql_* functions which were deprecated from php 5.5 and start use mysqli_* functions or PDO.

Then avoid using mysql_query() inside mysql_fetch_assoc() because if query fails you will get error. Always use die (mysql_error()) to find whether query has been executed correctly or not

so write coding like this

forphp > 5.2

$con = mysqli_connect("localhost","username","password","DBname");
$query=mysqli_query($con,"SELECT $fields FROM `users` WHERE `user_id` = $user_id") or die (mysqli_error($con));
$data = mysqli_fetch_assoc($query);

for php < 5.3

$query=mysql_query("SELECT $fields FROM `users` WHERE `user_id` = $user_id") or die (mysql_error());
$data = mysql_fetch_assoc($query);

Error : mysql_fetch_assoc ( Table Field Name )

2 Answers2