Ok client wanted to removed three fields from thieir application. I simply commented out the three fields in my code. Client then realized, for old requests, they still wanted to see the data. So I want to add code like attached, but i want to say if you are in display mode and the field Q_9 existist in the db for this record, show the attached info.
to test my theory i added q_9 back and removed data from it and it works, but the key here is Q_9 will no longer be used in the db, so how do i say if field/field name exists, ,show the data.
if ($mode=="display" && $Q['Q_9'] ==""):
//if ($mode=="display" && !empty($Q['Q_9'])):
<td width="210" class="required"><label><?=$Q['Q_9']?></label></td>