Re: problem with insert query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux