Page 1 of 1

MySQL table for exiting data

Posted: Thu Mar 11, 2004 9:10 am
by siliconpalms
I've been using MySQL for several months and enjoyed great success when installing other people's scripts to databses I make using phpMyAdmin.

My challenge is developing from scratch, for which I've got good resources, manuals and much time into practice and test.

My question is two-fold, as I have 14,000 records of Security Dealers that I want to install in MySQL at http://www.securitydealers.com

1) what should my table look like for data (sample) as follows;
"John Doe","Managing Partner","BM SECURITIES LTD.","P.O. Box 201","Grand Cayman","Cayman Islands,"","","345--555-5999",

2) once the table is created inside my database on MySQL, how do I load the data in?

Posted: Thu Mar 11, 2004 9:27 am
by Steveo31
1) what should my table look like for data (sample) as follows;
Well, you have 2 empty spaces... what is going there?

And by scratch, you mean by generating it with PHP on the fly?

Posted: Thu Mar 11, 2004 9:44 am
by siliconpalms
I was hoping those 2 empty spaces were for "email address" and "website" which is missing from my data.

From scratch; meaning to write the code or SQL statement to generate the table or/and learn how to write the PHP to access and display the data on an HTML page - for which I'm getting closer by using tutorials and practising etc...

Basically, my problem is that I can't get the data into the table because I've got the table structured incorrectly. When I read the MySQL manual it's very confusing and a little ambigious.