Hi,

I need to insert values using stored procedure using array or loop. For example I have a table with 2 columns name and tel_number. The user will enter name and tel_number 1, tel_number_2....in the website and when he clicks submit button, should populated the table with name and tel_numbers. Some user may enter 2 tel_number others may enter 5. Need help on this to capture and insert data in to table....Please help

You need to construct the INSERT statements for each tel_number available there and fire that on your sql server from the front end.

Is that the telephone numbers entered in the website are comma separated or entered into different text boxes?

_________________________
- Vijay G
Strive for Perfection