shortest route to return

[freelance84]

This may seem simple, but I have only been dealing with multiple returns from queries in the past. I now have a query where only one result is return, a string of text.

 

The query in PHP looks like:

 

$query_return_txt = "SELECT comment FROM matrix_general WHERE g_number = '$text[0]' AND a_number = '$text[1]' AND o_number = '$text[2]'";

 

The result of the query can only have one possible answer. What is the shortest way of getting the answer?

 

Is it:

$result = mysql_query($query_return_txt);
$row = mysql_fetch_row($result);
echo $row[0];

[Zane]

mysql_result

$result = mysql_query($query_return_txt);
$thereturn = mysql_result($result, 0);

[ignace]

list($comment) = mysql_fetch_row($result);

[freelance84]

ah brilliant. thanks.