Hello again!
Basically...you can't. What I meant was that when you insert the data
into the table, you need to store the size as well.
Consider the following table (called files):
dataID user filename size filedata
[int, autoincremented] [int] [varchar] [int] [blob]
Now, let's say user 3 upl
TED]>
Sent: Tuesday, January 14, 2003 9:36 PM
Subject: [PHP] Re: Amount of data in the database
> 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 reco
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(
3 matches
Mail list logo
