Warning: mysql_fetch_assoc

Question

I'm getting the following error:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/inv/public_html/set.php on line 19

Line 19 is:

    $row = mysql_fetch_assoc($result);

Full Code:

<?php

$sitename = "ASDASDCSGO";

$link = mysql_connect("localhost", "x", "y");

$db_selected = mysql_select_db('x', $link);

mysql_query("SET NAMES utf8");



function fetchinfo($rowname,$tablename,$finder,$findervalue) {

    if($finder == "1") $result = mysql_query("SELECT $rowname FROM $tablename");

    else $result = mysql_query("SELECT $rowname FROM $tablename WHERE `$finder`='$findervalue'");

    $row = mysql_fetch_assoc($result);

    return $row[$rowname];

}

?>

That happens when your query fails, Oh and look the _deprecated_ mysql functions, again. — DirtyBit, Sep 17 '15 at 14:16

Deepak saini · Answer 1 · 2015-09-17T14:31:48.573

0

This warning generates because your $result is null. check your result is boolean or not.

    <?php

$sitename = "ASDASDCSGO";

$link = mysql_connect("localhost", "x", "y");

$db_selected = mysql_select_db('x', $link);

mysql_query("SET NAMES utf8");



function fetchinfo($rowname,$tablename,$finder,$findervalue) {
     // you can't access php variable as a string in query
    if($finder == "1") $result = mysql_query("SELECT '.$rowname.' FROM '.$tablename.'");

    else $result = mysql_query("SELECT '.$rowname.' FROM '.$tablename.' WHERE '.$finder.'='.$findervalue.'");

    if(!is_bool($result)){ // this is for checking your $result varible is boolean or not
    $row = mysql_fetch_assoc($result);
    }else{
    echo "Error";
    }

    return $row[$rowname];

}

?>

edited Sep 17 '15 at 14:31

answered Sep 17 '15 at 14:17

Deepak saini

3,772
2
14
20

Please check again. now my answered is updated. – Deepak saini Sep 17 '15 at 14:23
@Pepo_rasta Its looking right, I think :) – Anshul Mishra Sep 17 '15 at 14:25
Please check you database connection in that case – Anshul Mishra Sep 17 '15 at 14:27
I think it's someting wrong with my phpmyadmin, because on my dosen't work, and friend mysql data base work... – Alexandru Marcs Sep 17 '15 at 16:15
First you have to check your Php variables. Check every variables have the value or not. – Deepak saini Sep 17 '15 at 16:21

Lemon Kazi · Answer 2 · 2015-11-30T10:24:13.790

<?php
function fetchinfo($rowname,$tablename,$finder,$findervalue) {

    if($finder == "1") $result = mysql_query("SELECT $rowname FROM $tablename");

    else $result = mysql_query("SELECT ".$rowname." FROM ".$tablename." WHERE ".$finder."=".$findervalue."");

    $row = mysql_fetch_assoc($result);

    return $row[$rowname];

}

or you can use your query like this

mysql_query('SELECT {$rowname} FROM {$tablename} WHERE {$finder}={findervalue}');

Warning: mysql_fetch_assoc

2 Answers2