Re: SQL Queries
| From: | Matthew Beers | Date: | Fri, 11 Aug 2000 17:35:28 +0000 |
| Subject: | Re: SQL Queries | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1971@lists.php.net to get a copy of this message | ||
Hello Nick,
NB> Tow quick questions ...
NB> 1/ Is it possible to select coun(*) from xxx where .... directly into a
NB> $variable? Rather than select * and mysql_numrows ...
You should be able to do:
$res = mysql_query("select count(*) from xxx where .....");
$rs = mysql_fetch_row($res);
$count = $rs[0];
Matt