mysql_fetch_assoc()

[Shazer2]

I am receiving this error:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/shannon/public_html/booter/inc/classes/class.db.php on line 17

For the function:

function fetch_array($query) {
    $array = mysql_fetch_assoc($query);
    return $array;
}

 

Why would I receive that error, if I am just passing a variable? Not a resource or boolean?

 

Thanks.

[SergeiSS]

This warning mean that you have an error in you MySQL request. Show it.

[Shazer2]

Well I'm calling it like this:

$query = $db->select("boot", "id, uid", "id=1");
while ($rows = $db->fetch_array($query)) {
echo $rows['id']." - ".$rows['uid'];
}

 

[SergeiSS]

$query = $db->select("boot", "id, uid", "id=1");

It's a very great line! But why are you sure that all people knows the internal part of this function, it's parameters and so on?

 

It's not a request, it's a call to the function that could do it and send to MySQL - I don't know, I can suggest it only.

[Shazer2]

Sorry, this is the function.

function select($table, $rows = "*", $cond = "") {
        $query = "SELECT {$rows} FROM `{$table}`";

        if ($cond != "") {
	$query .= " WHERE {$cond}";
}
return mysql_query($query);
}

[SergeiSS]

OK... You might have a query

 

SELECT id,uid FROM `boot` WHERE id=1

 

Did you try to execute it from phpmyadmin? It seems that something is wrong it this query. Function mysql_error() could be useful for you to see exactly what is wrong. You may try to use it just after you make a call to function select().

[Shazer2]

I just realised a few things, firstly I wasn't selecting a database and secondly I had the wrong table name. I corrected both but I'm still getting this error.

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/shannon/public_html/booter/inc/classes/class.db.php on line 18

[SergeiSS]

The only (real) way to solve this kind of problems is to see the text of query.

 

// Insert this code
echo $query.'<br>';
//before this
return mysql_query($query);

 

And then show this query here.

[Shazer2]

I figured it out, I guess I wasn't connecting OR selecting a database as in the construct for my DB class I was doing.

function __construct() {
return self::connect();
return self::select_db();
}

 

Instead of

function __construct() {
self::connect();
self::select_db();
}

 

I changed it to the second code, and now everything works fine.

 

Thanks for all the help!