Creating Tables Help! 1

[Guest_imported]

Ok, I need help creating tables. I have a site with all my setup php on thier webhosting program. Well, I don't know how to connect to their mysql interface without using phpMyAdmin. So i uploaded EVERY file for that into my ftp directory , and it starts fine.... BUT....

It won't display the mySQL database that this webhosting company supplied me. I don't know what to do!

PLEASE HELP! Is there a way to connect to a remote mySQL server from my computer without using phpMyAdmin? Thank you SOOOOOOOOO much!

 

[fxcolin]

Hi Danno,
I'm a web host and use phpMyAdmin and find it to be a pretty good program.
You should be able to find it at

http://www.yourdomain.com/phpMyAdmin

At that point you should have a password screen pop up and then it takes you to your main screen where you should have the name of your database at the top left. (If none of this appears or you are getting errors then contact your web host)
Once you click on the database name at the bottom you will have a choice: Run SQL query/queries on database
OR Location of the textfile:
The first one you can just copy and paste, the other one is for browsing your PC for a text file containing the table info.
Here's an example of creating a table;
CREATE TABLE glossary (
id int(4) auto_increment,
word VARCHAR (50) not null ,
definition TEXT not null ,
PRIMARY KEY (id)
);

try digging for some tutorials, especially with some of the meanings 'TEXT,VARCHAR,INT' etc. try

http://www.phpwizard.net

also there is an SQL forum here just type it in at the top.

http://www.chefmedia.ca