[RESOLVED] optimize script

[bumbar]

Hi!
I have this strange problem. This script get data from database and output it in html columns ($z). its all right but script is not optimize. I wait long time to execute query!

<table>
<?
$conn = db_connect();

$b = 10 ; //numbers to count for
$i = 0; // incrementor
$z = 3; // how much cols ?

$select = "select * from my_table";
$query1 = mysql_query ($select);

while($i < $b)
    {
		while ($row = mysql_fetch_array ($query1)) {

		if($i == 0 || $i == $a)
            {
                echo "<tr>";
                $a = $a + $z; // the beginning ist always $a + cols per row or zero
                $e = $a - 1; // the end ist always $a - 1 ;
                if ($e > $b) // if the end ist geater then our count 
                    {
                        $e = $b - 1; //we make $b - 1 and thats the end tag
                    }
            }    

            echo "<td> ". $i . $row [0] ." </td>";

        if ($i == $e) 
            {
                echo "</tr>";
            }
        $i++;
    }
}

?>
</table>

I have an massage:
Fatal error: Maximum execution time of 60 seconds exceeded in ....

Any id&#1077;a for optimize script? Thanks!

[laserlight]

Looks very complex. Consider this implementation:

<table>
<?php
$conn = db_connect();

$max_record_num = 10; // maximum number of database records (rows)
$records_per_row = 3; // number of database records (rows) per table row

// limit the number of rows retrieved from database in the query
$select = "select * from my_table LIMIT $max_record_num";
$query1 = mysql_query($select);

// begin looping through the result set
$i = 0;
while ($row = mysql_fetch_array ($query1))
{
    // print start of table row for a new row
    if ($i % $records_per_row == 0)
    {
        echo "<tr>";
    }

// print current record from database
echo "<td> " . $i . $row[0] . " </td>";

++$i; // must be done before the check of end of row

// print end of table row if row has ended
if ($i % $records_per_row == 0)
{
    echo "</tr>";
}
}

// account for gaps
if ($i % $records_per_row != 0)
{
    $max = $records_per_row - ($i % $records_per_row);
    for ($j = 0; $j < $max; ++$j)
    {
        echo "<td>&amp;nbsp;</td>";
    }
    echo "</tr>";
}
?>
</table>

[bumbar]

its work! Very thank you! 🙂

[Weedpacket]

$select = "select * ..... 

And just select what you're using, instead of mindlessly selecting everything.

[bumbar]

right . this optimize mysql server 🙂