Re: Query stopping after 2 records?
| From: | Hawx | Date: | Mon, 27 Apr 2009 14:38:13 +0000 |
| Subject: | Re: Query stopping after 2 records? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46147@lists.php.net to get a copy of this message | ||
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.
--
Hawx