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
combo box for navigation how?
Moderator: General Moderators
- jayshields
- DevNet Resident
- Posts: 1912
- Joined: Mon Aug 22, 2005 12:11 pm
- Location: Leeds/Manchester, England
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.
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 logicjayshields 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.
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.