
July 30th, 2004, 01:49 PM
|
|
Registered User
|
|
Join Date: Jul 2004
Posts: 17
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
select WHERE from previous form?
Is it possible to have a WHERE clause select from a form filled out on the previous page? Like SELECT * FROM tblname WHERE City= and then here I want the city to be selected from the form on the previous page. Is this possible? The name of the form is, lets say, city1. So how do I tell WHERE that it needs to see what city was selected in that form and then search for that city in the db? SELECT * FROM tblname WHERE City=?? any help would be appreciated. Its just a text field on the previous form so they just type the city, so if they mistype it then no records will be displayed but I dont care about this for now.
Thanks
|