...

View Full Version : attach multiple numbers and store in db



Kal
11-28-2006, 11:10 AM
Hi Guys,

i have a simple form consisting of name, tel_no, mob_no, sales, flag which gets sent and stored in a mysql database and an email get sent as well.

however each customer could have upto 100 telephone numbers is there any way of allowing a user to add upto 100 telephone numbers for one customer and also store each different telephone number as a new record in the database?

any help would be great

thanks in advance.

chump2877
11-28-2006, 02:19 PM
do you really need each each telephone number to have its own row in your DB?...I would use some kind of delimiter, and store all 100 phone numbers in the same row/cell, so a row might look like this (you get the idea, hopefully):


Joe Smith 354-533-5590|345-694-6909|293-578-0943 mob_no sales flag

When you call the row information from the database, you can use explode() (http://us2.php.net/manual/en/function.explode.php) to get each individual numner into an array:


$phone_nos = explode("|", $row['tel_no']);
echo $phone_nos[0]; // 354-533-5590
echo $phone_nos[1]; // 345-694-6909
echo $phone_nos[2]; // 293-578-0943

marek_mar
11-28-2006, 03:45 PM
do you really need each each telephone number to have its own row in your DB?
It's a good idea in general.
Having the phone numbers in a seperate table would allow you to select only these that you need, not all, to search them and sort them.

chump2877
11-28-2006, 10:57 PM
Personally, I would save myself the effort (and space, perhaps) of having to create a new table for each name in my database that only stored that person's phone numbers, when I could just as well search and sort the person's phone numbers array in PHP...but to each his/her own, I guess...:)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum