one record per webpage issues

[Anon]

I have information about people in only one table. This information contains information that I want displayed in "application" form, meaning, I want it to look like a job/college/credit application when a user runs a query.

AS of now, I can only display the record fields - one in a column, or one record field per row.

(i.e.- <tr><td>first name</td></tr>
<tr><td>last name</td></tr>)

-OR-

(i.e.-<td>first name</td>
<td>Last name</td>)

I want a way to place a static label next to what the contents of the field actually is. Meaning, I want the Fname field to have a label of 'First Name' to the left of the row. I think you can understand what this is, I have it set up for one record per query.

How do I approach getting what I want in one printable page that a user can print out and fax.

Thanks for any help, I really appreciate it. Let me know if you need more information.

Nick
[e-mail]

[Anon]

Two ways to approach this.

My preferred method is using mysql_fetch_assoc to retrieve the record from the database and then using a for(list($sLabel,$sField) = each($aRecord)) construct to loop through the fields.

Alternatively use "select 'First Name',first_name" type sql to retrieve the fixed and variable parts of your data.

Combine the two mechanisms and you can use the sql to define the label you want to show.

[Anon]

Jef,

Thanks a lot, that will be helpful. Any idea how I can present it on the screen so it looks like an applicaiton would? with boxes around the field records and such?