Using an array with MySQL

[henry14]

Hi,

I have an array which has list of names (100~) and I would like to put each name into my database such that I can query each name independantly. Is there any way I can do this?

Thanks

[venelin13]

You should insert each name on a separate row in a database table. That is how you can query each name independantly.

//array of names
$names = array("name 1", "name 2", "name 3");

//lets suppose you table strucutre is:
CREATE table tbl_names (
name_id int(10) not null primary key auto_increment,
client_name varchar(50) not null
);

//and the sql code you need is:
foreach($names as $client_name){
$sql = "INSERT INTO table_name VALUES ('', $client_name)";
}

[henry14]

Sounds about right, i'll give it a try. Thanks alot :)