Fetching MYSQL records in PHP HTML rendring -


i have mysql table 400000 records , query of them till no problem when want loop records, takes 1 or 2 minutes rendering <li> , question best way doing or rending faster?

my code:

$result = mysql_query('select series ticket_no           customer           status = 0           order id           limit 400000'           );  <ul class="lottery slot">     <?php       while ($row = mysql_fetch_array($result)) {             ?>             <li><span><?=$row['ticket_no']?></span></li>      <?php  } ?> </ul> 


Comments

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

windows - Debug iNetMgr.exe unhandle exception System.Management.Automation.CmdletInvocationException -

configurationsection - activeMq-5.13.3 setup configurations for wildfly 10.0.0 -