I don't see how this is weighted.
I would suggest doing it the easy way and treating the options as
keywords and just putting them all in a text field with a fulltext
index. this will give you the weighting you want and it will be a lot
easier to deal with, but you will have to watch out for thin
I don't see how this is weighted.
The count(car_id) and group_by should give a "score" for each car_id.
I neglected to use "count(car_id) as score" and to add "order by score desc"
though.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additio
How about solving both problems at once? :-)
Yes, go with the N:N (the technical term for that car_option table)
relation, *AND* give yourself a weighted search engine to boot!
create table car (car_id auto_increment...);
create table option (option_id auto_increment...);
create table car_option
- Original Message -
From: "Rich Cavanaugh" <[EMAIL PROTECTED]>
To: "Dave Mariner" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 1:53 AM
Subject: RE: [PHP] [OT-ish] Optional Extras.
> Dave,
> I did something simi
s,
so his solution was fast and simple and efficient.
i agree with the second point, that having
hundreds or thousands of options would definately
degrade performance.
> -Original Message-
> From: Dave Mariner [mailto:[EMAIL PROTECTED]]
> Subject: Re: [PHP] [OT-ish] Optional
- Original Message -
From: "David Robley" <[EMAIL PROTECTED]>
To: "Dave Mariner" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 4:32 AM
Subject: Re: [PHP] [OT-ish] Optional Extras.
> Why not have a table that contains c
- Original Message -
From: "..s.c.o.t.t.." <[EMAIL PROTECTED]>
To: "Php-General" <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 7:35 AM
Subject: RE: [PHP] [OT-ish] Optional Extras.
> off the top of my head, you could try using a
> "lookup table&qu
On Tue, 26 Jun 2001 05:23, Dave Mariner wrote:
> Please excuse me if you consider this to be off-topic, but this is the
> best place I can think of to ask the (slightly long-winded) question.
>
> Imagine you have a car database (MySQL driven). Different models have
> different optional extras (air
> From: Dave Mariner [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 25, 2001 12:54
> To: [EMAIL PROTECTED]
> Subject: [PHP] [OT-ish] Optional Extras.
>
>
> Please excuse me if you consider this to be off-topic, but this is the best
> place I can think of to ask the (
e best match to worst match.
again - this is all off the top of my head, I'm sure it's not word for word
correct.
--
Rich Cavanaugh
-Original Message-
From: Dave Mariner [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 3:54 PM
To: [EMAIL PROTECTED]
Subject: [PHP] [OT-ish]
Please excuse me if you consider this to be off-topic, but this is the best
place I can think of to ask the (slightly long-winded) question.
Imagine you have a car database (MySQL driven). Different models have
different optional extras (air-con, central locking, immobiliser etc). I
need to store
11 matches
Mail list logo
