Re: Query stopping after 2 records?
| From: | Bastien Koert | Date: | Mon, 27 Apr 2009 14:21:57 +0000 |
| Subject: | Re: Query stopping after 2 records? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46146@lists.php.net to get a copy of this message | ||
On Mon, Apr 27, 2009 at 10:19 AM, 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
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
echo out each sql statement and then change the or die to
mysql_query($query) or die (mysql_error());
--
Bastien
Cat, the other other white meat