I haven't seen a way to get the size of an individual record. What about using the max size of the fields in that table against number of records eg:
255 char = x bytes etc etc = 156KB per record max Timothy Hitchens (HiTCHO) Open Platform Consulting e-mail: [EMAIL PROTECTED] > -----Original Message----- > From: Denis L. Menezes [mailto:[EMAIL PROTECTED]] > Sent: Sunday, 12 January 2003 4:10 PM > To: [EMAIL PROTECTED]; 'PHP general list' > Subject: Re: [PHP] Amount of data in the database > > > Thanks Timothy. > > I want to find the amount of data for each member in the > database using PHP and displaying in a web page. I know how > to query records of a member and also know to display. Only I > need to know the command for finding the size(in bytes or kb) > for each of these records :Something like seeing the file > sizes of each email in hotmail. > > > Thanks > Denis > ----- Original Message ----- > From: "Timothy Hitchens (HiTCHO)" <[EMAIL PROTECTED]> > To: "'Denis L. Menezes'" <[EMAIL PROTECTED]>; "'PHP > general list'" <[EMAIL PROTECTED]> > Sent: Sunday, January 12, 2003 1:29 PM > Subject: RE: [PHP] Amount of data in the database > > > > Give this a go.. for each of the databases use: > > > > SHOW TABLE STATUS FROM xxxxxx; > > > > That will return a huge amount of size etc data!! > > > > > > > > Timothy Hitchens (HiTCHO) > > Open Platform Consulting > > e-mail: [EMAIL PROTECTED] > > > > > -----Original Message----- > > > From: Denis L. Menezes [mailto:[EMAIL PROTECTED]] > > > Sent: Sunday, 12 January 2003 2:58 PM > > > To: PHP general list > > > Subject: [PHP] Amount of data in the database > > > > > > > > > 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
