Scoring a query

[theraj]

Hi,

I'm building a dating website and have come across a bridge in my coding that I'm having difficulty crossing.

I'm trying to order the result of a query according to a scoring system.

Example:

If blond hair 1 point. If black hair 2 points.
If <20 years old 3 point. If >20 years old 4 points.
If <160cm 1 point. If >160cm 3 points.
Order query result according to the scoring rule above.

How does one go about coding a scoring method for something like this?

Am using PHP4 and MySQL.

Thanks,

Raj

[devinemke]

a simple example
assumptions:
the table is called table
the primary key field is called id
there are fields called hair, years and cm

$result = mysql_query('SELECT id, hair, years, cm FROM table');
while ($row = mysql_fetch_assoc($result))
{
	$score = 0;
	extract($row);

if ($hair == 'blond') {$score += 1;}
if ($hair == 'black') {$score += 2;}

if ($years < 20) {$score += 3;}
if ($years >= 20) {$score += 4;}

if ($cm < 160) {$score += 1;}
if ($cm >= 160) {$score += 4;}

$array[$id] = $score;
}
asort($array);
foreach ($array as $key => $value)
{
	echo 'ID: ' . $key . ' score: ' . $value . '<br>';
}

[theraj]

devinemke,

you've saved me again.

Thankyou again and don't hesitate to contact me if you think I can help you out in any way. Raj