[Resolved] HELP -> MySQL query display question

[blueman]

Hello Fellas...

This should be an easy one to you....

I am having a hard time to echo the result from a query in MySQL.
the result should be a single row from only one column:

the variable client_id is passed via form action

$client_name = mysql_query("select name from clients where client_id='$client_id' ");
$cli_name_array = array($client_name);
echo "<b>".$client_name_array[0]."</b>";

the echo command returns "RESOURCE #4" for example

Can someone help writting the right statement so it returns the actual value??

thanks in advance...

[Pig]

$result = mysql_query("select name from clients where client_id='$client_id' ");
$row = mysql_fetch_row($result);
$my_var = $row[0];