Re: [PHP] Need to count number of rows per id! :(

Are you looking for select topicID, count(*) from $secondtable group by topicID? This will give you a count of each distinct topicID in $secondtable. Julian -- Julian Wood Multimedia Developer University of Calgary on 2/2/01 6:15 PM, Sandeep Hundal at [EMAIL PROTECTED] wrote: > > Hey g

[PHP] Need to count number of rows per id! :(

Hey guys, I need an answer to a problem I've been trying to work on for days :( I made a message board, which has a front page which lists Topic name, topic started by, and what date. All this info, and the topic message is stored in one mysql table. when you click on any of the topics, it leads