[RESOLVED] No result for query ???

[dmacman1962]

Hi all,

I dont know why this query is not returning a value, when I should be getting the value of '15'.

mysql_select_db($dbname, $conn) or die (mysql_error());
	$query = "SELECT MIN(q_id) FROM questions2 WHERE quiz_id='".$quiz_id."'";
	echo $query.'<br />';
		$result = mysql_query($query) or die(mysql_error());
			$row = mysql_fetch_array($result) or die(mysql_error());
				$first = $row['q_id'];
				echo 'first='.$first.'<br />';

Does anyone see something I don't?
Thanks,
Don

[Piranha]

You have to give MIN(q_id) a name. Something like this:

$query = "SELECT MIN(q_id) as min_q_id FROM questions2 WHERE quiz_id='".$quiz_id."'"; 

[dmacman1962]

Thanks Piranha,

I missed that. I also found that I could define it right in the row statement too.

$first = $row['MIN(q_id)'];

Thanks,
Don