Problem with MIN SQL in PHP 1

[jimoblak]

I am having trouble with the following SQL. It works fine directly in MySQL but my PHP web page prints nothing. Does anyone have a clue why this is happening?

$Link = mysql_connect ($Host, $User, $Password);
$Query = "SELECT MIN(myfield) FROM `mytable`";
$Result = mysql_db_query ($DBName, $Query, $Link);
while ($Row = mysql_fetch_array ($Result)) {
print ("$Row[myfield]");
}
mysql_close ($Link);

The variables to connect to MySQL are set up properly. Other queries in the page work fine. I'm new to using MIN and this may be the problem.

- - picklefish - -

 

[jimoblak]

I found that the print line of

print ("$Row[0]");

seems to work. Suggestions for alternate print lines are still welcome.

- - picklefish - -

 

[DRJ478]

Suggestion:

I would assign an ALIAS to the returned field:

SELECT MIN(myField) AS minimum FROM `myTable`

Then you can access it as

$row["minimum"]