query string single value return

[Anon]

Hi there

The code example below will return 1 value. Is there an easier way(less code) way of extracting just 1 value.

$result = mysql_query("SELECT MAX(issue) as parms FROM tableName");
while ($row = mysql_fetch_array($result))
{ $row["parms"] }

THANKS

[Anon]

just drop the "while" - it would loop only one time anyway.

$result = ...
$row = mysql_fetch_array($result);

echo $row["parms"];

voilà!

[Anon]

Cheers for that mate.

Cannot believe i didnt think of this.