Hi,

This is going to seem trivial for all of you, but I hope you can spare me a
min.

I have a page, in which I want it to modify a SQL query depending on a
users' selection.  For exampls, the following SQL:

SELECT * FROM advert_details WHERE county = 'berks'

What I need to do is have a Select drop down box, which I have dynamically
populated, as a second option - "To filter data, please choose a category" -
then that would modify the SQL,hopefully, to read:

SELECT * FROM advert_details WHERE county = 'berks' and category = 143

How can I do this?

Thanks,

Will

------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to