dennismonsewicz Posted April 2, 2009 Share Posted April 2, 2009 I have wrote my own backend to my personal website and am looking to see how to count how many posts are in a particular section (or subject). Code: $query = mysql_query("SELECT * FROM sections")or die(mysql_error()); while($row = mysql_fetch_object($query)) { echo '<p>'; echo '<a href="cat.php?action=view&catid=' . $row->section_id . '" class="blogpost"><img src="images/arrow.gif" alt="arrow"/>' . ucwords($row->sections) . '</a>'; echo '</p>'; } Link to comment https://forums.phpfreaks.com/topic/152254-solved-counting-with-sql/ Share on other sites More sharing options...
premiso Posted April 2, 2009 Share Posted April 2, 2009 Post your table structure. This should also of been posted in the MySQL Help section, as an FYI. Link to comment https://forums.phpfreaks.com/topic/152254-solved-counting-with-sql/#findComment-799539 Share on other sites More sharing options...
dgoosens Posted April 2, 2009 Share Posted April 2, 2009 just use COUNT in your SQL statement SELECT COUNT(*) FROM sections Link to comment https://forums.phpfreaks.com/topic/152254-solved-counting-with-sql/#findComment-799541 Share on other sites More sharing options...
dennismonsewicz Posted April 2, 2009 Author Share Posted April 2, 2009 I was able to accomplish what I needed using mysql_num_rows Link to comment https://forums.phpfreaks.com/topic/152254-solved-counting-with-sql/#findComment-799571 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.