On Mon, 27 Apr 2009 07:19:23 -0700, "Miller, Terion"
<tmil...@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.
--
Hawx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
