rashmi_k28 Posted July 31, 2008 Share Posted July 31, 2008 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"); } Quote Link to comment Share on other sites More sharing options...
Orionsbelter Posted July 31, 2008 Share Posted July 31, 2008 STOP BEING LAZY! look on google there is many articles on this Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.