Best practice for large page w/ MySQL...

[ludachris]

http://www.homeloancorp.com/los/test.html

Here is an example of what I am going to be outputting. My question is what is the best/fastest way to do this.

A) Do a query and store data in variables (ie a bunch of these.. $fname=$row['fname']; ) then close the connection and output the HTML with includes calling the variables ($fname) stored at the query.

😎 Do a query and echo all of it and call them by '.$row['fname'].' etc. where needed and close the connection at the end of the page almost.

My concern with option B was that holding open the connection and outputting all that code might cause it to be slow?

Also, since there is only ONE record, should I still be using "while ($row = mysql_fetch_array($result)){ "

Let me know if I am not making any sense. =P Thanks in advance!!

[devinemke]

the connection will be closed when the script finnishes anyway regardless of when/if you output anything to the browser. if you only expect 1 row to be returned from your query then you do not need the while loop.

[ludachris]

I realise that it would open and close either way but my thought was pulling the info and storing into variables then ouputting html might be an alternative.

The other way would be to ouput info from MySQL while outputting HTML at the same time THEN closing the connection.

My question is, which one? I usually use '.$row['whatever'].' while echoing HTML but this will be a large page.