combo box for navigation how?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rami
Forum Contributor
Posts: 217
Joined: Thu Sep 15, 2005 8:55 am

combo box for navigation how?

Post 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
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Post 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.
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

wrong forum

moved
rami
Forum Contributor
Posts: 217
Joined: Thu Sep 15, 2005 8:55 am

Post 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.
Post Reply