Re: 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)" <hitcho@php.net> To: "'Denis L. Menezes'" <menezesd@singnet.com.sg>; "'PHP general list'" <php-general@lists.php.net> 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: tim@hitcho.com.au > > > -----Original Message----- > > From: Denis L. Menezes [mailto:menezesd@singnet.com.sg] > > 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 > >