DARTHTAMPON
12-05-2004, 09:12 PM
I have this code
<?php
$values = "";
$titles = "";
if ($_POST['turbotype'])
{
$chosenvalue = $_POST['turbotype'];
}
$query = "SELECT products.productid, products.name FROM products, types where products.typeid = types.typeid and types.producttype = 'turbo'";
$result = querydatabase ($query);
$row = @mysql_num_rows($result);
$x = 0;
while ($x < $row)
{
$values[$x] = mysql_result($result, $x, "productid");
/*178*/$titles[$x] = mysql_result($result, $x, "name");
}
$name = "turbotype";
buildselectstatement ($values, $titles, $name, $chosenvalue, "" );
?>
Now the error given to me is Fatal error: Maximum execution time of 60 seconds exceeded in engines.php on line 178 .
When I perform the query on the actual db I get 1 record with 2 columns. I thought that maybe values and titles should be initialized to null, I did and I still receive the errors.
any ideas???
<?php
$values = "";
$titles = "";
if ($_POST['turbotype'])
{
$chosenvalue = $_POST['turbotype'];
}
$query = "SELECT products.productid, products.name FROM products, types where products.typeid = types.typeid and types.producttype = 'turbo'";
$result = querydatabase ($query);
$row = @mysql_num_rows($result);
$x = 0;
while ($x < $row)
{
$values[$x] = mysql_result($result, $x, "productid");
/*178*/$titles[$x] = mysql_result($result, $x, "name");
}
$name = "turbotype";
buildselectstatement ($values, $titles, $name, $chosenvalue, "" );
?>
Now the error given to me is Fatal error: Maximum execution time of 60 seconds exceeded in engines.php on line 178 .
When I perform the query on the actual db I get 1 record with 2 columns. I thought that maybe values and titles should be initialized to null, I did and I still receive the errors.
any ideas???