Empty set but has a result

[nebulom]

I have a weird problem. The query seems to be empty but I got a result resource.

$query = 'SELECT ...';
print_r($this->db . '<br>');
$result = mysql_query($query, $this->db);
print_r($result);
if ($result) {
$price_max_schedules = mysql_result($result, 0, "value");
}
Outputs:
Resource id #72
Resource id #97
I know I'm missing something but I can't seem to find it. Help anyone? Thanks in advance!

[kows]

remember that mysql_query() returns a resource on a successful SELECT statement, or false on an error. that doesn't mean something is actually being returned, though -- it just means that the query was successfully executed. then, you're trying to print_r() to resources ($this->db and $result) and because of that you're getting the resource IDs echoed out. you'll need to check mysql_num_rows() to see if a result was actually returned. I'd also suggest using something like mysql_fetch_assoc() if you'd like an easier way of returning values from your result.

a quick example of using mysql_num_rows() and mysql_fetch_assoc():

$sql = "SELECT field1, field2 FROM table";
$result = mysql_query($sql);

//check if a row was returned
if(mysql_num_rows($result) > 0){

$row = mysql_fetch_assoc($result);

print_r($row);

}else{

echo "no results for {$sql}";

}

[nebulom]

Thanks man.