title: fastest way to display mysql db records
body: <p>I have slow query problem, may be i am wrong, here is what i want,</p>
  
  <p>i have to display more than 40 drop down lists at a single page with same fields , fetched by db, but i feel that the query takes much time to execute and also use more resources..</p>
  
  <p>here is an example...</p>
  
  <pre><code>$sql_query = "SELECT * FROM tbl_name";
  $rows = mysql_query($sql_query);
  </code></pre>
  
  <p>now i use while loop to print all records in that query in drop down list,</p>
  
  <p>but i have to reprint same record in next drop down list up to 40 lists, so i use </p>
  
  <p><code>mysql_data_seek()</code> to move to first record and then reprint the next list and so on till 40 lists.</p>
  
  <p>but this was seems slow to me so i use the second method like this same query for all 40 lists</p>
  
  <pre><code>$sql_query2 = "SELECT * FROM tbl_name";
  $rows2 = mysql_query($sql_query2);
  </code></pre>
  
  <p>do you think that i wrong about the speed of query, or do you suggest me the another way that is faster than these methods....</p>