Re: writing a MySQL search function

John Corry wrote: > > Now, what I really need to do is modify the .php file that displays the > results, so that I can pass the necessary query variables via a search form. > I need to be able to search by all or one or none (or any combination) of, I > guess 4-5 fields from the db... > > How do you write the query? I'm thinking that the query has to be If I understand you correctly - and I probably don't - you are wanting something like SELECT x, y, z FROM tbl_foo WHERE x > 1; x, y, z are the column titles in which you are interested (those 4-5 fields). Hope that helped, Jason -- Jason Murray Developer jWeb New Media Design