"Resource id #12" issue

[Guest]

Hi there,

 

I have a problem with a query:

<?php 
$sql = "SELECT SUM(room_fee) FROM function_room WHERE event_id = '$sel_event[id]'";
$result = mysql_query($sql);
echo "$result";
?>

 

When I perform this query in phpMyAdmin, I get the number I want but when I put that in one of the pages of my website, I get a "Resource id #12" instead.

 

Any idea what I did wrong?

 

Thanks for your answers.

 

Cheers,

[Mchl]

You have to fetch data from $result.

See examples here mysql_query

[Guest]

Actually, I found the solution right after posting here. Here is what I did if it can help some people:

<?php 
$sql = "SELECT SUM(bedroom_total) FROM bedrooms WHERE event_id='$sel_event[id]'";
$result = mysql_query($sql);
$r = mysql_fetch_row($result);
echo "$r[0]";
?>

 

Thanks anyway!