ceo@xxxxxxxxx schreef: > select > first_name like '%$first_name%' > + 3 * last_name like '%$last_name%' > + 7 * email = '$email' > as score, that works?? I guess the expressions (e.g. email = '$email') evaluate to bools and are auto-cast to ints. Im guess there needs to be some parenthesis in there somewhere, no? anyway nice snippet :-) > first_name, last_name, email, person_id > from person > . > . > . > order by score desc > limit 10 > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php