If the query stopped after getting 2 entries then this has nothing to do
with max_execution_time.
But stupid topic anyway, I don't know why are we even trying to figure
what Miller meant, he most probably solved it already...
Andrew Hucks napsal(a):
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
