from_postcode
to_postcode
wagon_type
move_date
load_value
load_status
I'm querying the table to find all the loads that are from or to a location, of a certain wagon type, the move date is between 2 dates and the load status is available. I use the following where clause
WHERE (from_pc = '%s' or loads.to_pc = '%s') AND (loads.type_wagon like '%s' AND loads.move_date >= '%s' AND loads.move_date <= '%s' AND loads.load_value <= %s AND load_status = 'Available')
I'm achieving the desired results but I need to be able to display them with the best match first, as you would see in full text search results but I don't think full text searching is going to work on this or is it????
Any help greatfully recieved.