Re: [PHP] Using PHP to get size of mySQL data?

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. |
`---------------------------------------------'