Re: Row Count
| From: | Daniel Brown | Date: | Tue, 10 Jun 2008 19:58:14 +0000 |
| Subject: | Re: Row Count | ||
| References: | 1 2 3 4 5 6 7 8 9 10 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-275209@lists.php.net to get a copy of this message | ||
On Tue, Jun 10, 2008 at 3:51 PM, Jim Lucas <lists@cmsws.com> wrote:
>
> So in your query, add this
>
> SELECT COUNT(*) as total FROM your_table
>
> Then in your code use this instead
>
> $rows = $rowcount['total'];
>
> This makes a little more sense then using the count(*) thing, to me at least
Good call. I should've added the 'as name' portion to my query to
begin with. Jim's way is much nicer.
--
</Daniel P. Brown>
Dedicated Servers - Intel 2.4GHz w/2TB bandwidth/mo. starting at just
$59.99/mo. with no contract!
Dedicated servers, VPS, and hosting from $2.50/mo.