Re: Using PHP to get size of mySQL data?
| From: | Robert Cummings | Date: | Sat, 23 Aug 2003 03:03:24 +0000 |
| Subject: | Re: Using PHP to get size of mySQL data? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-160480@lists.php.net to get a copy of this message | ||
Untested, but looks about right:
select sum( length( article_text ) ) as total
from articles_table
where user_id = 'user to match";
This is SQL though, so it's kinda OT.
Cheers,
Rob.
On Fri, 2003-08-22 at 22:45, Jeff Lewis wrote:
> I want to query a table of text articles and when selecting them I am
> wondering if I can grab the actual size of the articles in question.
>
> So if someone has two articles, I want to see if they have reache 100kb
> in total.
>
> Does that make sense to anyone? is that possible with PHP?
>
> Jeff
--
.---------------------------------------------.
| Worlds of Carnage - http://www.wocmud.org |
:---------------------------------------------:
| Come visit a world of myth and legend where |
| fantastical creatures come to life and the |
| stuff of nightmares grasp for your soul. |
`---------------------------------------------'