Pulling Variable from Mysql Table

[josephicon]

Hi All

 

I Currently have:

 

print "" .(($get_fields->fieldname == "id" ) ? "<input name=$get_fields->fieldname value=$nextid $get_fields->fieldview" :"other box").

 

I would prefer to keep  $nextid in the table itself so that I am not limited to the "id" field and its variable and output it as $nextid which is defined on the page . is this possible.

 

If not how can I add more conditions as opossed to the current to the current 2 print eg $get_fields->fieldname == "status" $get_fields->fieldname == "sector".

 

Many Thanks

[josephicon]

If my question was not clear enough I will add that I would basicly like to create html input boxes based on a mysql table but also adding value from a page variable dependent on table result.

[trq]

Pardon?