hi,
a. I have a form where a user has to select a company name to update.
b. Currently, i use a code where the first few alphabets of the company name are typed, a radio button used to selected one of the results that pop up and then another 2 scripts update the data.
c. Is it possible to select company name and update on the same form ?
d. My table structures are :
CID(int), Company (varchar) : Table :Customers
CAID(int), CID(int), Cityid(int), Street(var char), Postcode(varchar) : Table : Custaddress
e. So if a user types "exam" , company names like Example inc, Example com get listed. From these, the user chooses say, Example inc. whose address is to be modified.
f. Then another script selects say the 3 addresses linked to Example inc and then again the user chooses one of them to be modified.
g. Then next script allows editing this address and the data thus posted in the final script updates it in the db.
h. I would like steps (e) and (f) to be done on a single form in one script .
i. I cannot use JS as the number of cos. are over 500 .
Would anyone be able to suggest how best I could go about this ? I dont know ajax btw.
Thanks
Swati