Jump to content


Photo

how can I get the number of tables in a database?


  • Please log in to reply
2 replies to this topic

#1 alarik149

alarik149
  • Members
  • PipPipPip
  • Advanced Member
  • 60 posts

Posted 14 March 2006 - 04:08 PM

I relally need to get the number of tables into a specific database.how can I do that?
Tired of math homework ? Just visit http://www.solvemymath.com for a free online math solver and calculator.
Videochat bucuresti studio -> http://www.GirlAddicts.com
About the adult video chat business -> www.girlplan.com

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 14 March 2006 - 04:15 PM

$query = "SHOW TABLES"; 
 $result = mysql_query($query); 
 $num_of_tables = mysql_num_rows($result);  


should do the trick :)
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge

#3 alarik149

alarik149
  • Members
  • PipPipPip
  • Advanced Member
  • 60 posts

Posted 14 March 2006 - 04:20 PM

shocker-z you are so omni-present:))
tanks a lot,it works,and I think at the moment you guys had a lot of me,I just finished the script I was working for so I'll take a small break:).See you soon guys:)
Tired of math homework ? Just visit http://www.solvemymath.com for a free online math solver and calculator.
Videochat bucuresti studio -> http://www.GirlAddicts.com
About the adult video chat business -> www.girlplan.com




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users