note 37130 added to function.mysql-num-rows
| From: | php-general at lists dot php dot net | Date: | Tue, 04 Nov 2003 12:31:16 +0000 |
| Subject: | note 37130 added to function.mysql-num-rows | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-59856@lists.php.net to get a copy of this message | ||
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!
----
Manual Page -- http://www.php.net/manual/en/function.mysql-num-rows.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+37130
Delete -- http://master.php.net/manage/user-notes.php?action=delete+37130&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+37130&report=yes
Search -- http://master.php.net/manage/user-notes.php