Hi all i have a doubt from the following code i am able to insert single record at a time from notepad to mysql database how can i insert multiple records into mysql database using php

<?php 
            $conn=mysql_connect("localhost","root","root") or die("cannot connect".mysql_error()); 
            $db=mysql_select_db("kb"); 
                $target_path = "details.txt"; 
                    $fcontents = file ($target_path); 
                    for($i=0; $i<sizeof($fcontents); $i++) 
                    { 
                    $line = trim($fcontents[$i]); 

                    $arr = explode(":",$fcontents[$i]); } 
$a=trim($arr[1]); 
                 $firstname=explode(":",$fcontents[0]); 
                     $firstname1= $firstname[1]; 
                     $a=explode(":",$fcontents[1]); 
                     $lastname =$a[1]; 
                     $b=explode(":",$fcontents[2]); 
                     $address= $b[1]; 
                     $c=explode(":",$fcontents[3]); 
                     $city= $c[1]; 
             $d=explode(":",$fcontents[4]); 
                     $state= $d[1]; 
$e=explode(":",$fcontents[5]); 
                         $zip= $e[1]; 
$f=explode(":",$fcontents[6]); 
                         $email= $f[1]; 
$g=explode(":",$fcontents[7]); 
                         $telephone= $g[1]; 
                         $h=explode(":",$fcontents[8]); 
                         $contacttype= $h[1]; 
                             $uplsubscriber = "insert into habitat_coupon_subscribers4(FirstName,LastName,Address,City,State,Zip, Email,ContactType,WorkPhone) values 
('".$firstname1."','".$lastname."','".$address."','".$city."','".$state."','".$zip."','".$email."','".$telephone."','".$contacttype."')";                                     
$result = mysql_query($uplsubscriber); if($result===false) $_SESSION['errMessage'] = "upload failed"; /* details.txt FirstName: Jeanette LastName: Burleson Address: 417 PARK RIDGE RD City: ALBEMARLE State: NC Zip: 28001 EMail: bburleson@carolina.rr.com TelePhone: 704-982-7733 ContactType: Realtor */ /*table1 CREATE TABLE `habitat_coupon_subscribers4` ( `subscriber_id` int(10) unsigned NOT NULL auto_increment, `user_id` int(5) unsigned NOT NULL default '0', `FirstName` varchar(45) default NULL, `LastName` varchar(45) default NULL, `Address` varchar(45) default NULL, `City` varchar(45) NOT NULL default '', `State` varchar(20) default NULL, `Zip` varchar(11) default NULL, `Email` varchar(60) default NULL, `ContactType` varchar(7) default NULL, `WorkPhone` varchar(45) default NULL, `issubscribe` smallint(5) unsigned default '0', `isdeleted` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`subscriber_id`), KEY `FK_ecoup_coupon_subscribers_1` (`user_id`) ); CREATE TABLE `ecoup_coupon_subscribers1` ( `subscriber_id` int(10) unsigned NOT NULL auto_increment, `user_id` int(5) unsigned NOT NULL default '0', `subscriber_name` varchar(45) default NULL, `subscriber_address` varchar(45) default NULL, `email` varchar(45) NOT NULL default '', `issubscribe` smallint(5) unsigned default '0', `isdeleted` tinyint(3) unsigned NOT NULL default '0', `city` varchar(45) default NULL, `state` varchar(45) default NULL, `zip` varchar(45) default NULL, PRIMARY KEY (`subscriber_id`), KEY `FK_ecoup_coupon_subscribers_1` (`user_id`) ); */ ?>
    Write a Reply...