note 37130 deleted from function.mysql-num-rows by vincent
| From: | vincent@php.net | Date: | Tue, 04 Nov 2003 13:14:13 +0000 |
| Subject: | note 37130 deleted from function.mysql-num-rows by vincent | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-59888@lists.php.net to get a copy of this message | ||
Note Submitter:
----
I want got next feature. Is possible?
task:
total rows in table - 50
id is unique field.
query:
select count(*) from table,
and
select id from table where id=1;
two query ... :( Is bad for me.
I can use, something ....
one SUPER query:
select count(*) as totalrowsintable, id from 'table' where id=1 ?
count(*) return's 1 (not 50) :((
Please help me!