[SOLVED] counting with sql

[dennismonsewicz]

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>';
}

[premiso]

Post your table structure. This should also of been posted in the MySQL Help section, as an FYI.

[dgoosens]

just use COUNT in your SQL statement

 

SELECT COUNT(*) FROM sections

[dennismonsewicz]

I was able to accomplish what I needed using mysql_num_rows