Re: Query stopping after 2 records?

Hawx wrote:

On Mon, 27 Apr 2009 07:19:23 -0700, "Miller, Terion" <tmiller@springfi.gannett.com> 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.

No - use the mysql_real_escape_string function. Addslashes is the wrong thing to use here. -- Postgresql & php tutorials http://www.designmagick.com/