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
Post a Comment