Problem with a query....

[Brad]

Anyone tell me why the following query doesnt return a value for min_score? Not sure why this isnt working. any help would be appreciated.

select min(score) as min_score from rounds where username='".$user."' and course='".$course."';

[Frederick]

NO

select min(score) as min_score from rounds where username='".$user."' and course='".$course."';

YES

$sql = "select min(score) as min_score from rounds where username='$user' and course='$course' ";

[Brad]

The code above is the same thing as what I was using. it still gives me a null value for min_score. I've been at this for a while, anyother suggestions?

[Weedpacket]

So how are you getting at the value for min_score? The only way I can see your query failing is if there were no results returned for that combination of user and course.

[Frederick]

My question to you is how are you trying to display the results?

$sql = "select min(score) as min_score from rounds where username='$user' and course='$course' ";
$row = mysql_fetch_array($sql);
echo $row["min_score"];

OR

$sql = "select min(score) from rounds where username='$user' and course='$course' ";
$min_score = mysql_result($sql,0,0);

[ctatravel]

have you tried just printing what $sql means, it should recognise your variable prior to the query, if it doesn't then you know thats the problem, if it does print it out correctly then you know its a syntax error in your sql statement

[Brad]

Looks like I wasnt paying a lot of attention on how I was outputting the variable. I got stuck paying too much attention to the query and not enough on how I was outputting the variable...
Thanks guys for the help, I owe you one!