I'm not sure if there is an SQL statement, but a short amount of PHP code
will do this...
just run thru each row you need to check, and do
while ($myrow = mysql fetch row ($result)) {
$mailboxsize += strlen( $myrow["emailbody"] );
}
Siggy
----- Original Message -----
From: "phpLover" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 6:18 PM
Subject: [PHP-DB] Record Size
> I am sorry for posting this question here. I cannot find any mySQL news
> group so please bear this question here.
>
> I have made an online email sort of system and backend database is MySQL
for
> all inbox messages. To every user, I give 1mb space for his inbox. Now I
> want to see if a users inbox exceeds the 1mb quote, I want to give him a
> warning. How can I get this size from the database. The inbox messages are
> stored in a text field.
>
> Thanks
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
