indexing ?

[shailen]

Hi,

do you have a script that returns the results having the maximum matching criteria and then the lowest when a research is made from a MySql database?

Regards,

Shailen

[Anon]

<?
$result = mysql_query ("SELECT * FROM table WHERE id > low_number AND id < high_number");
?>

is this what you mean?

[shailen]

Thanks but it's not what i am trying to do.

My sql statement is "select hotelname from hotel where hotelrating = '$cboStarRating' or scuba = '$xscuba' or data = '$xdata'"

So, i want to have all the records having the hotelrating, scuba and data first (all the three), then having two matching records and having one matching records.

Do u have any idea about how to do it?

Thanks

Shailen