Re: Re: Passing a PHP variable to javascript
| From: | Pag | Date: | Mon, 19 Aug 2002 16:55:11 +0000 |
| Subject: | Re: Re: Passing a PHP variable to javascript | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-113232@lists.php.net to get a copy of this message | ||
Hi, i am coding a news manager backend for a client and i ran into a little problem.
I have two tables, one with the news and one with the comments on each news.
How can i count how many comments there are for each news entry? Simply put, is there some sort of Mysql command query that can count how many records exist with a given field content?
Example:
Count on a database how many "peter"s there are in there?
Is there a specific SQL select or something, or i have to make a loop just to count them?
Thanks.
/Pag