The "horrible" structure... I am using a program called Machform to create the form that enters the info into the database. This program gives the horrible names you are noting. And yes, they are hard to work with, especially since my form has 65 fields.

I added the WHERE as you had it (WHERE id=".$id, but I got this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

When I change it to WHERE ap_form_1.id, I do not get the error message, but I still only get the first record from the database.

$id have some value or may be its blank?

$id is the record number as assigned by the database. There are currently 2 records in the database -- 1 and 2. When you click on either record, it displays the first one and it shows the record number to the left of the street address. So not blank.