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

2003-08-22 Thread Jeff Lewis
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 


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

2003-08-22 Thread Robert Cummings
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.|
`-'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php