noobstar Posted December 8, 2006 Share Posted December 8, 2006 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]<?phpsession_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 :) Quote Link to comment Share on other sites More sharing options...
wolves Posted December 8, 2006 Share Posted December 8, 2006 $result = mysql_fetch_array($count);print_r($result); Quote Link to comment Share on other sites More sharing options...
noobstar Posted December 8, 2006 Author Share Posted December 8, 2006 Oki this is what happend when i ran itArray ( [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] Quote Link to comment Share on other sites More sharing options...
Orio Posted December 8, 2006 Share Posted December 8, 2006 [code]<?phpsession_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. Quote Link to comment Share on other sites More sharing options...
noobstar Posted December 8, 2006 Author Share Posted December 8, 2006 M8 your champ thx :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.