When you say die, does it just stop, or do you get an error message?
Depending on how long it's taking to perform the action, the script
will stop just because it's taking a while. (by default, I think it's
30 seconds.)
If so, use: ini_set("max_execution_time", "time in seconds");
On Mon, May 4, 2009 at 3:43 PM, Martin Zvarík <mzvarik@xxxxxxxxx> wrote:
> Miller, Terion napsal(a):
>>
>> 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
>>
>
>
> Should be:
> ------------------
>
> $sql = ...
>
> $query = mysql_query($sql) or die(...
>
> while ($r = mysql_fetch_array($query)) { ....
>
> ------------------
>
> Notice that you need to assign the mysql_query to a $query variable!
>
>
> If you understand this, then there's most probably a mistake in your SQL
> statement.
>
>
> Martin
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
