I think you have to run multiple queries, ie run some loop after finding out
what topics you wil count from e==>
run a select distinct to get the topics
run a while or for loop then run queries again like count(*) where
topic='$topic'
etc
then echo the result to each line
-----Original Message-----
From: DC [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 9:53 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] count function?
Ok i think i need to expand my help request... my fault....
I have a db that uses ids for topics in a message board ie each topic has
messages of various numbers in them.
>From my select a topic page i hope to put the number of messages in the
topic, so it visually looks like this sort of...
topic 1 bbbbbb (5 posts)
topic 2 ffffff (2 posts
and so on.
The only constant i can see in the tables is my posts table which specifies
the topic id number.
So i think i am asking how can i count the number of the same topic id
numbers and show that next to the relevant topic.
Thanks Again
Dave C
"Andrei Skorokhod" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> if you just need the number
>
> SELECT COUNT(*) FROM table where ................
>
> At 06:34 PM 3/30/2001 +0100, DC wrote:
> >Hi All
> >I cant quite work out how to count the number of rows in my mysql db that
> >match a certain critieria and the show that number numericaly in my
pages.
> >
> >Checked books, php.net etc.
> >
> >Any help is appreciated
> >
> >Yours Dave C
> >
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]