delphi123 Posted January 31, 2008 Share Posted January 31, 2008 Hi I'm wanting to have a php page that displays the number of posts by a person. There's a column called author in my database that holds this value, I'm wondering how I can do this? Is there some way of counting the number of rows in a database that have a column with value x? Quote Link to comment Share on other sites More sharing options...
laffin Posted January 31, 2008 Share Posted January 31, 2008 SELECT COUNT(*) FROM posts WHERE user='x'; Quote Link to comment Share on other sites More sharing options...
delphi123 Posted January 31, 2008 Author Share Posted January 31, 2008 brilliant cheers! (easier than I was expecting!) Quote Link to comment Share on other sites More sharing options...
delphi123 Posted January 31, 2008 Author Share Posted January 31, 2008 hmmm - stupid additional question - how do I now print this value? I've tried echo $result after my query but it just says resource id #14?! Quote Link to comment Share on other sites More sharing options...
haku Posted January 31, 2008 Share Posted January 31, 2008 $result = mysql_fetch_array($result) echo $result[0]; Quote Link to comment Share on other sites More sharing options...
delphi123 Posted January 31, 2008 Author Share Posted January 31, 2008 oh I feel stupid! Quote Link to comment Share on other sites More sharing options...
laffin Posted January 31, 2008 Share Posted January 31, 2008 if($res=mysql_query("SELECT COUNT(*) FROM posts WHERE user='x';")) { $row=mysql_result($res,0); } else $posts=0; shud do it Quote Link to comment Share on other sites More sharing options...
delphi123 Posted January 31, 2008 Author Share Posted January 31, 2008 thanks Laffin - that's actually really useful - the way you did it is not something I'd thought of, so my code can be much neater now! Is it possible to 'stack' the where statements? Ie I'm now looking to show the posts that person x has posted in the last week, so I'd need something like: count(x) where author='x' and where date='less than 7 days from current time' Quote Link to comment Share on other sites More sharing options...
laffin Posted January 31, 2008 Share Posted January 31, 2008 SELECT COUNT(*) FROM posts WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= date_field; Quote Link to comment Share on other sites More sharing options...
delphi123 Posted January 31, 2008 Author Share Posted January 31, 2008 brilliant - thanks so much Laffin, you've been a great help with this! Quote Link to comment Share on other sites More sharing options...
laffin Posted January 31, 2008 Share Posted January 31, 2008 No probs, hope ya gets yer project going 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.