count statement

[noobstar]

Hello everyone,

I was wondering if someone could help me in this i know this is pretty stupid and a really small problem however, i can't get my head around it.

This is what im trying to do:

[code]<?php

session_start();
mysql_connect("localhost", "root", "") or die('Could not connect: ' . mysql_error());
mysql_select_db("forum") or die('Could not select database');

// Counts all the posts the specific username has made
$count = mysql_query("select count(username) from forum_post where username='".$_SESSION['username']."'") or die('Query failed: ' . mysql_error());

echo $count;

?>[/code]


... but every time i run it i get this: [b]Resource id #4[/b]

I honestly never came across this error.

Anyone got any ideas or suggestions?

Thank you very much in advance for any replies :)

[wolves]

$result = mysql_fetch_array($count);

print_r($result);

[noobstar]

Oki this is what happend when i ran it

Array ( [0] => 2 [count(username)] => 2 )

Is there a way to display the count as just purly a number i.e. Posts made by bla: [b]53[/b]

[Orio]

[code]<?php

session_start();
mysql_connect("localhost", "root", "") or die('Could not connect: ' . mysql_error());
mysql_select_db("forum") or die('Could not select database');

// Counts all the posts the specific username has made
$count = mysql_query("select count(username) as count from forum_post where username='".$_SESSION['username']."'") or die('Query failed: ' . mysql_error());
$result = mysql_fetch_array($count);
echo $result['count'];

?>[/code]

Orio.

[noobstar]

M8 your champ thx :)