problem with insert query
| From: | Ahmed Abdelaliem | Date: | Sat, 07 Jun 2003 12:15:53 +0000 |
| Subject: | problem with insert query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28411@lists.php.net to get a copy of this message | ||
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]."')"; _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus