Page 1 of 1

combo box for navigation how?

Posted: Sat Sep 17, 2005 8:55 am
by rami
there are records in the tables
table(id,firstname,lname,email,phone,web.....)
how to make a combo box that contain firstname and when name is selected and may be click see data button a page is dispalyed where is is all records for that selected people

i think it
select * from table where=..
i am confused about where part
how to pass reference from that combo box to that page to select

any idea or example or tutorial which can help me

thanks
rami

Posted: Sat Sep 17, 2005 10:20 am
by jayshields
a combo box as in a drop down box? you would need to

SELECT * FROM tablename WHERE firstname = 'firstnamehere';

You would need to run an SQL query to fetch all the first names, and then make the drop down box from the results of the query. then make the see data button direct to a page and that page runs the query above, and then shows the results.

Posted: Sat Sep 17, 2005 11:35 am
by JayBird
wrong forum

moved

Posted: Sat Sep 17, 2005 10:59 pm
by rami
jayshields wrote:a combo box as in a drop down box? you would need to

SELECT * FROM tablename WHERE firstname = 'firstnamehere';

You would need to run an SQL query to fetch all the first names, and then make the drop down box from the results of the query. then make the see data button direct to a page and that page runs the query above, and then shows the results.
you are describing as if i know all the things and just asking the logic
i think that was very confusing ...may be not illustrative

there is a box
ok i also got how to put data from table in combo box

problem is when the firstname is choosen and clicked may be GO button how that firstname is pass to another page which shows details about that firstname

is it using
?$_GET[first_name] or what

no examples?

alleast that might have solved it.