RE: [PHP] easy mysql question

2001-07-08 Thread Ben Bleything
Do you mean to output the current structure of the table? Check out http://www.mysql.com/doc/m/y/mysqldump.html. Mysqldump will do that for you... If you mean a syntax reference, check www.mysql.com. If you didn't mean either of those things, Sorry = Ben -Original Message- From:

Re: [PHP] easy mysql question

2001-07-08 Thread Mark Charette
On Sunday 08 July 2001 21:48, [EMAIL PROTECTED] wrote: Since I first made the tables for my site I've had to modify them quite a bit. I always keep a copy of the commands I used to make the tables in case I need to move a site. Is there a way to ask mysql to list the create table commands?

Re: [PHP] easy mysql question

2001-07-08 Thread Chris Kay
if you use phpMyAdmin you can dump the structure and data to a file and use phpMyAdmin to place it on a new machine At 10:48 PM 7/8/01 -0400, [EMAIL PROTECTED] wrote: Since I first made the tables for my site I've had to modify them quite a bit. I always keep a copy of the commands I used to

RE: [PHP] easy mysql question

2001-07-08 Thread Don Read
On 09-Jul-01 [EMAIL PROTECTED] wrote: Since I first made the tables for my site I've had to modify them quite a bit. I always keep a copy of the commands I used to make the tables in case I need to move a site. Is there a way to ask mysql to list the create table commands? $ mysqldump -d

Re: [PHP] Easy MySQL question

2001-01-11 Thread Nicolas Windpassinger - Sun
Joseph, here it is: Number of manpages in db: ?php $sql = "SELECT count(*) FROM manpagetool.manpages"; $result= mysql_query($sql); $number = mysql_fetch_array($result); echo $number["count(*)"]; ? hope that's