August 5th, 2000, 12:44 AM
I am new to MySQL & database programming in general. I need your help in this matter please.
I've got a table for events: event_id, title, start_date, end_date, category, specialty, center, city, country.
I would like to do a search in the events table utilizing a form where user can search either by Title or Date or Center or City or Country or Any combination of these parameters like Title & Date, or Date & Country, etc.
I tried several scripts, such putting all these parameters in one query separated by OR. And I tried another query separating these parameters by AND. But both didn't work.
I really need your valuable help.
August 7th, 2000, 10:25 PM
Can you post a fragment that shows what kind of sql you were trying ??