It seems to me that this code will not provide useful information: if ($result) echo mysql_affected_rows()." affected."; If the insert was successful, it will always say "1 affected." Since you are only inserting one row at a time. On Sat, 07 Jun 2003 08:49:15 -0400, Becoming Digital wrote: > Try this. I made some minor syntax changes and added some error reporting. > While it may not fix things, it might help you figure out what's wrong. > > <? > $mails=file("mails.txt"); > $number_of_mails = count($mails); > > for ($i=0; $i<$number_of_mails; $i++) > { > $link = @ mysql_connect("localhost") > or die( mysql_error() ); > $db = mysql_select_db("me2resh00", $link); > $query = "insert into recipients (recipient_name, > recipient_email) values > (\"friend\", \"".$mails[$i]."\")"; > $result = mysql_query($query); > if ($result) > echo mysql_affected_rows()." affected."; > } > ?> > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > ----- Original Message ----- > From: "Ahmed Abdelaliem" <ahmed_abdelaliem@hotmail.com> > To: <php-db@lists.php.net> > Sent: Saturday, 07 June, 2003 08:15 > Subject: problem with insert query > > > hi > i am wrote a script to read e-malis from a file and insert it into the > tables of database > i get error when i write it > here is the code > can anyone tell me what is wrong? > > <? > $mails=file("mails.txt"); > $number_of_mails = count($mails); > > for ($i=0; $i<$number_of_mails; $i++){ > > @ $db = mysql_connect("localhost"); > mysql_select_db("me2resh00"); > $query = "insert into recipients (recipient_name, recipient_email) values > ('"friend"', '".$mails[$i]."')"; > $result = mysql_query($query); > if ($result) > echo mysql_affected_rows()." affected."; > > } > ?> > > > here is the error that i get > > Parse error: parse error in enter.php on line 9 > > > and line 9 is > > $query = "insert into recipients (recipient_name, recipient_email) values > ('"friend"', '".$mails[$i]."')"; --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php