Re: mysql query
| From: | Chris Hewitt | Date: | Sun, 27 Apr 2003 13:33:47 +0000 |
| Subject: | Re: mysql query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-145415@lists.php.net to get a copy of this message | ||
Dave Watson wrote:
folks, could you tell me how to construct a query in php to count from certain mysql table fields how many are null please. thanks, dave.How about: select count(*) from mytable where myfield is null; I think the "is null" is OK in myql, you will need to test it. I suggest that you check in the mysql manual, this is not a php question. HTH Chris