Counting values from MySQL

[Chris.P]

I have the following code. Basically I'm trying to count the amount of colours returned in the $colour variable. What I have is always returning 1, any ideas why?

 

$colour = $db->query("SELECT * FROM colours WHERE prod_id = ".$row['prod_id']." AND LENGTH(col_image_1) > 0 ORDER BY col_rank ASC LIMIT 1");
$colourcount = mysql_num_rows($colour);

if($db->numrows($colour)) {
	$colour = $db->fetchrow($colour);
} else {
	unset($colour);
}

 

echo $colourcount;

 

 

 

[teynon]

LIMIT 1 in your sql query limits it to 1 every time.