optimize

[rashmi_k28]

In the below code how can I optimize the query.

Yhe fieldname has more than 3 rows for the particular id.

 

The while loop takes longer time to open the page if there are more records.

 

So how can I optimize the query so that speed increases

 

 

$result = mysql_query("select * from table1");
                $no_of_rows += mysql_num_rows($result);
        while($r = mysql_fetch_array($result)){
                $fieldname = '';
                $res = mysql_query("select distinct(filed) from table2 where id='".$r[0]."'");
                
                while($row = mysql_fetch_array($res)){
                   $fieldname .= $row[0]."\n";
                        }
                
                                array_push($records, "$r[0]#$r[1]#$r[2]#$r[3]#$r[4]#$r[5]#$fieldname");
                }

[Orionsbelter]

STOP BEING LAZY! look on google there is many articles on this