Trouble with printinig results from MySQL query

[Stranger_php]

Hi !
I get "array" on my page when do this code...

<?php
$dbh=mysql_connect ('localhost', '****', '*****') or
die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ('bmjru_data');
$query = mysql_query('SELECT `club` FROM `tournres` WHERE dbid = 1 LIMIT 0, 30');
$res =mysql_fetch_row($query); 
echo $res;
mysql_close();
?>

..And I couldn't understand because when i do this query in phpmyadmin i receive right results...

[laserlight]

Read the PHP Manual on [man]mysql_fetch_row/man.

[crzyman]

I am new to php, but try this. I think it will work for you.

$query = mysql_query('SELECT club FROM tournres WHERE dbid = 1 LIMIT 0, 30');

while($r=mysql_fetch_array($query))
{
$res=$r["club"];
echo $res;
}
mysql_close();
?>

[obrienkev]

mysql_fetch_row($query) will create an array

Try echo $res[0]; and you will see.

Maybe print_r($res); will help you.