Confusion about where db is created

[harlequin2k5]

In an earlier post I had asked about making a switch to mysql/php and was found that I could download mysql and then later found that I could use the phpmyadmin in my ftp admin panel

I'm so confused right now it's not even funny...

I went ahead and created a database using my local mysql as I've been unable to create one on phpmyadmin - this is the error I get
Error

SQL-query :

CREATE TABLE `wholesalerlist` (

`WholesalerID` INT( 50 ) BINARY NOT NULL AUTO_INCREMENT ,
`WholersalerName` TEXT( 50 ) BINARY NOT NULL ,
`WholesalerAddress1` TEXT( 50 ) BINARY,
`WholesalerAddress2` TEXT( 50 ) BINARY,
`WholesalerCity` TEXT( 50 ) BINARY,
`WholesalerState` TEXT( 50 ) BINARY,
`WholesalerZip` TEXT( 50 ) BINARY,
`WholesalerPhone` TEXT( 50 ) BINARY,
`WholesalerFax` TEXT( 50 ) BINARY,
`WholesalerEmail` TEXT( 50 ) BINARY,
`WholesalerURL` TEXT( 50 ) BINARY,
PRIMARY KEY ( `WholesalerID` ) ,
INDEX ( `WholersalerName` )
) COMMENT = 'Wholesalers List'

MySQL said:


You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BINARY NOT NULL AUTO_INCREMENT, `WholersalerName` TEXT(50) BINA
I see that it keeps referencing "localhost" and this is what is confusing me as my computer is not the server (suncoastwebdes.wholesalerlist running on localhost - phpMyAdmin 2.5.0)

When I go into my admin panel I have the option to setup a new access db/dsn or MySQL Admin Tool which takes me direct to phpMySQLAdmin

I'm completely lost and any help is greatly appreciated

[harlequin2k5]

I went back step by step and found that I was not using the correct column type - I have since been able to create the table using phpmysqladmin

thanks for your time!

[vinyl-junkie]

Glad to know that you got your problem solved. One thing you might keep in mind for future issues like this is to let phpMyAdmin do all the work for you, unless you've already got a pre-made script, or you just like to hand-code. Since creating a new database and tables is generally a one-time thing, just let phpMyAdmin do the job for you. :)