[RESOLVED] Error: Maximum execution time of 30 seconds exceeded

[jarriola]

Hi guys,
How do I solve this error: Maximum execution time of 30 seconds exceeded.
I've searched through many site, but have no luck.
Please help, i really need this.

This is my code:
<? ....
set_time_limit(30);

$query = mysql_query("SELECT * FROM $usertable WHERE $method LIKE '%$search%'");
$row = mysql_fetch_array($query);
$result = "$row";
while ($result);
{
echo "<table border=1>";
echo "<tr><td>Classification:</td><td>".$row['Class']."</td></tr>";
echo "<tr><td>Name:</td><td><strong>".$row['Ename']."</strong></td></tr>";
echo "<tr><td>Address:</td><td>".$row['Bar']."</td></tr>";
echo "<tr><td>Name:</td><td><strong>".$row['Pro']."</strong></td></tr>";
echo "</table>";
echo "<br/>";
}
... and so on.

[ucffool]

$row = mysql_fetch_array($query);
$result = "$row";
while ($result);

get rid or this, then do:

while ($row = mysql_fetch_array($query){
// all that other stuff
}

mysql_fetch_array returns a single row of the results, and if all you wanted was the first row, you could just run it once. Since you want to run the echo's for each row, you need to do a while statement as above, which will continue for each row (until mysql_fetch_array() returns FALSE because it ran out of rows.

[dougal85]

jarriola wrote:

$result = "$row";

the problem was also because you put quites around $row. This converted it to a string.

Strings convert to true in PHP, unless they are blank "" or contain "0" I think.

Anyway, so effectively you where doing while $result == true, and as a string its always true. Thus an infinite loop.

[jarriola]

i see...hehe.that was quite sooo basic.yet i did made an error. thnx..thumbs up!

[halojoy]

dougal85 wrote:

the problem was also because you put quites around $row. This converted it to a string.

Strings convert to true in PHP, unless they are blank "" or contain "0" I think.

Anyway, so effectively you where doing while $result == true, and as a string its always true. Thus an infinite loop.

Thses are the facts:

<?php

$row = 17;

echo '1.something happend at line: $row';
echo '<br />';
echo '2.something happend at line: '  .  '$row';
echo '<br />';
echo '<hr />';

echo "3.something happend at line: $row";
echo '<br />';
echo "4.something happend at line: "  .  "$row";
echo '<br />';
echo "5.something happend at line: "  .  $row;
echo '<br />';
echo '<hr />';

// This is what I use myself, I put any variables OUTSIDE of string
// and join them to string by using  'puncts':   .
echo 'something happend at line: '  .  $row  .  ' ... just as I expected';
echo '<br />';


?>