[RESOLVED] SQL Question

NZ_Kiwis

I have this code which looks for results where trip_id is = to trip however I also want to select all items sometimes.. is there a way i can select all trip_id's I dunno maybe somekind of wild card "%"

$sql = mysql_query("$query_list where trip_id = $trip ORDER BY id $dd LIMIT $from, $max_results");

NZ_Kiwis

Or would something this work

$qrr = "trip_id < '1' && > '9' ";

???

NogDog

Not sure what you are looking for, but perhaps the BETWEEN function would help?

Piranha

If you don't use a where-part in the query all the rows will be returned.

NZ_Kiwis

Piranha wrote:
If you don't use a where-part in the query all the rows will be returned.

Sometimes I make things harder than they need to be.