Re: [PHP-DB] Query stopping after 2 records?

On Mon, 27 Apr 2009 07:19:23 -0700, "Miller, Terion"
<[email protected]> wrote:
> I need help/advice figuring out why my query dies after 2 records.  Here
is
> the query:
> 
>          // Build your INSERT statement here
>       
> 
>  $query = "INSERT into `warrants` (wid, name, age, warrant, bond,
wnumber,
> crime) VALUES (";
>     $query .= " '$wid', '$name', '$age', '$warrant',
> '$bond', '$wnumber', '$crime' )";
>         $wid = mysql_insert_id();
> 
> // run query
>     
>  mysql_query($query) or die ("GRRRRRRR");
> 
> 
>   echo $query;
> 
> It inserts two records and dies half way thru the 3rd?
> Thanks in advance for clues to fix this.
> T.Miller

Make sure any apostrophes in the variable strings are escaped correctly.
Check the addslashes() function.

-- 
Hawx