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...
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
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 t
At 10:06 AM 3/30/01 -0800, Larry Rivera wrote:
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'
Better yet
Cheers Brian
Thats sounds more like i am looking for
Although i have put the other code examples offered for this prob in my code
folder for later cause you never now when you'll need them.
Cheers
Dave C
""Brian S. Dunworth"" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
What is retrieved if you do a Select Count(*) from myDb where
condition = parameters?
Seems your result set should contain this value...
Phil J.
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
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,