Table and PHP scripts for existing data

From: Aaron (aaron_at_siliconpalms.com)
Date: 03/11/04


Date: 11 Mar 2004 07:27:11 -0800

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 the scripts, for which I've
got good resources, manuals, and much time into practice and test.

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

1) what should my table SQL statement 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?

3) what is the best choice of variables, operators and arrays for my
PHP script, to display only records from a certain city, country,
company name or Dealer name?



Relevant Pages

  • Re: permissions dilemma
    ... On Apr 29, 2006, at 2:07 PM, Gerard Seibert wrote: ... informed that the screen saver daemon wasn't running. ... I tried installing MySQL twice, each time with the same problem. ...
    (freebsd-questions)
  • Re: permissions dilemma
    ... immediately on start up with permission to create/write it's .pid ... informed that the screen saver daemon wasn't running. ... I tried installing MySQL twice, each time with the same problem. ...
    (freebsd-questions)
  • Re: permissions dilemma
    ... immediately on start up with permission to create/write it's .pid file ... informed that the screen saver daemon wasn't running. ... I tried installing MySQL twice, each time with the same problem. ...
    (freebsd-questions)
  • Re: MySQL permission
    ... > you after installing the initial database you would not have this problem. ... I just gave the command "sudo yum install mysql-server". ... on my MySQL server, and have not had any problems on that score. ...
    (comp.os.linux.misc)
  • Re: permissions dilemma
    ... immediately on start up with permission to create/write it's .pid ... informed that the screen saver daemon wasn't running. ... I tried installing MySQL twice, each time with the same problem. ...
    (freebsd-questions)