Display complex search results to show best match
Posted: Fri Jun 11, 2004 5:05 am
I have a table that holds:
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.

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.