how to display an "avg" query ??

[vronsky]

Hello everybody,I'm brand new in this forum.

My problem:

$query = "select avg(column1) from my_table where column2 like \" this_way\" ";

$result = mysql_query($query);

now I need a function to echo() my $result.

Not mysql_fetch_array() ... it is only one result
Not my_sql_fetch object() ...it is an average datum

Help : wich one??

Thank you!

[piersk]

Try:

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

[vronsky]

😃

ahahahahahahahahahahahahah

IT WORKS....

thank you,sir....smak smak...wont you marry me??
I can take you here,in Rome,and we'll stay always together...for ever and ever....near the Colosseo,the Fontana di Trevi,eating spaghetti,or whtever you like....

😃

ciaoooooooooooooo

[piersk]

Nice as your offer sounds, I think we should keep our relationship purely platonic 😃