[PHP] Re: Amount of data in the database

[Lars Olsson]

A pretty easy way of doing it is to add a size field to the table. Whenever you INSERT INTO or UPDATE the table, update this field to contain the size of the data for the current record. Then, whenever you need to check the amount of data for a particular user, just use this query:

"SELECT SUM(size) FROM sometable WHERE user=someuser"

Hope this helps


/Lars Olsson ([EMAIL PROTECTED])

PS. Ive done this in a file upload script I created a while ago. If you want, I can mail you the relevant bits and bytes. DS.



Denis L. Menezes wrote:

Hello friends.

I have a need for checking how much data(in kb) exists of each of the user members in the MySQL so that when they upload more data I can restrict/warn them of the amount of data they have on the server at present.

can anyone please tell me how to check the amount of data on the mysql for each record?

thanks very much
Denis

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