Re: Record Size
| From: | phobo | Date: | Sun, 04 Feb 2001 07:57:15 +0000 |
| Subject: | Re: Record Size | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6349@lists.php.net to get a copy of this message | ||
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" <tabarry@email.com>
To: <php-db@lists.php.net>
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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>