sql server - Good Way To Fetch / Display Large Data From Sql Query Using PHP (Fix Memory Limit) -

sql server - Good Way To Fetch / Display Large Data From Sql Query Using PHP (Fix Memory Limit) -

i have problem maybe has face too. when creating study (basic html) i'll code :

<?php //query string $query = "select * table ... "; $sql = mssql_query($query); //fetch array , display on browser while($row=mssql_fetch_assoc($sql)){ //display row in here $row[] } ?>

using code above (with understanding) info save memory (array) before take i'm gonna them (for example, display on browser). if low data, script running well.

but when goes big amount of data, not working because browser display getting memory limit or in case browser display nothing. dont planning using paging display big data. want inquire of is, maybe of know way or trick handle this.

wish share solution or way case. best regards

php sql-server