MySQL table for exiting data

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
siliconpalms
Forum Newbie
Posts: 3
Joined: Tue Mar 09, 2004 9:06 am
Location: Sao Paulo, Brasil

MySQL table for exiting data

Post 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?
Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

Post 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?
User avatar
siliconpalms
Forum Newbie
Posts: 3
Joined: Tue Mar 09, 2004 9:06 am
Location: Sao Paulo, Brasil

Post 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.
Post Reply