Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

drew22299 · 05-03-2007, 08:41 AM

Hey,

I have a script written in asp and I have modified some of the SQL to search the database for specific things that I have specified in WHERE.

How would I write an SQL query in Php or asp to search the database based on the user input? for example, if the user types in the name of a town or city and make it search the fields in the database based on what they typed?

Thanks!

05-03-2007, 08:41 AM	#1 (permalink)
drew22299 Junior Member Join Date: Mar 2006 Location: Wilts / Bristol Posts: 54	Can anyone help me with this SQL query? Hey, I have a script written in asp and I have modified some of the SQL to search the database for specific things that I have specified in WHERE. How would I write an SQL query in Php or asp to search the database based on the user input? for example, if the user types in the name of a town or city and make it search the fields in the database based on what they typed? Thanks! __________________ www.hotlista.co.uk