I'd like to know if there's alot of difference (performance wise) between:
- executing a query, looping the result rows & adding them to an array, then assigning them to the template, then looping through them once more to display.
- executing a query, assigning result to template, then looping over result set (mysql_fetch_assoc()) to display each row.
Also, second method: Will there be an accumulation of memory if I assign like 5 different result resources before I begin looping over them? ($result = mysql_query(..); assign to template)