Jump to content

Size of Table

- - - - -
Started by dirkfirst, May 18 2006 05:03 AM

This topic has been archived. This means that you cannot reply to this topic.
2 replies to this topic

#1
dirkfirst
Posted 18 May 2006 - 05:03 AM

dirkfirst

    Programming Expert

  • Members
  • PipPipPipPipPipPip
  • 354 posts
how can i get a size of a table in bytes , anyone knows ??

#2
Crane
Posted 20 May 2006 - 04:33 AM

Crane

    Programming Expert

  • Members
  • PipPipPipPipPipPip
  • 398 posts 

$sql = "SHOW TABLE STATUS";

$result = mysql_query($sql);

while($row = mysql_fetch_array($result))

{

            $total = $row['Data_length']+$row['Index_length'];

}

echo($total);

#3
Lop
Posted 06 August 2006 - 09:44 AM

Lop

    Speaks fluent binary

  • Members
  • PipPipPipPipPipPipPipPip
  • 1,172 posts
Should work perfect. Did you get this working?
Back to PHP Development




  1. CODECALL Programming Forum
  2. → Web Development Forum
  3. → PHP Development
IPB skins by Skinbox