Creating new tables in mySQL?

[LLaffer]

I have phpBB, so I have a working mySQL setup.

What I want to do is add custom tables into my database for my own php script I want to write outside of phpBB and its tables.

I was playing with php on my personal linux box, so I know how to make tables (unfortunaly, it requires the use of the shell prompt, which of course we don't have at PowWeb.)

SO, as you may have guessed, what is the best way to create tables in my tablespace?

(go as techy as you want, you won't scare me)

Thanks in advance for any help you can offer.

[BerksWebGuy]

Many people use the GUI phpmyadmin at www.phpmyadmin.net .

Simple database manager...works like SQL Enterprise.

Is that what you were looking for??

[HalfaBee]

Your script could create the table itself.

mysql_query( " create table newtablename ( ...... )" );

fill in the dots with your table definition

HalfaBee

[LLaffer]

Originally posted by BerksWebGuy
Many people use the GUI phpmyadmin at www.phpmyadmin.net .

Simple database manager...works like SQL Enterprise.

Is that what you were looking for??

Perfect! This does exactly what I was looking for and more!

Nice to see also that powweb doesn't require us have those silly !#/usr/local/bin/php anymore .. I remember doing that to get phpBB going, and was worried that I needed to do that all over here.

Thanks for your help.

[BerksWebGuy]

You're not out of the blue yet.

You do have to set some server paths...but most of the time you don't have to change them...but you do have to check on the paths.

[LLaffer]

Hmm .. I didn't change the MyAdmin .php files at all and they all work flawlessly .. I'll start removing some from my phpBB files to see if they break or not sometime when this current project that I'm on is completed.

[BerksWebGuy]

Powweb uses standard paths...as well as most scripts. But sometimes you're gonna come across one you gotta change.