[rjbzzr400]

Hi,

I have an access database in this format:

package_name  feature1  feature2  feature3
bronze			  yes		 no		  yes
silver				no		  yes		 no
gold				  no		  yes		 yes

and I have a webpage with a selection of drop down boxes that let the user
choose which features they require and when the form is submitted it communicates
with my database using SQLite.

Is there a way I can return the package from the database that matches
the majority of the user's selected requirements using PHP?

Thanks for any help

[Auzzie]

http://uk.php.net/ma.../ref.sqlite.php not quite sure what your after so there

[rjbzzr400]

Once the user has selected which features they require (yes or no), I want to do a search on the databse that compares the user's requirements to each row and returns the row that matches exactly or has the majority of matches

Webpage with drop down boxes --> Query to database --> Return row that matches majority of answers

Basically I would like to know how to do a search, but if there is not a row that matches exactly, I want to return the row that matches the most fields. I can do an exact match search but not a partial match search.

Hope that makes sense

[baavgai]

Let's say I have tables that look like this:

Feature
	FeatureId
	Name

Package
	PackageId
	Name

PackageFeature
	PackageId
	FeatureId

It then becomes as simple as asking the database:

select PackageId, count(FeatureId) FeatureCount
	from PackageFeature
	where FeatureId in (2,3,4,6)
	group by PackageId
	order by count(FeatureId) desc

There are a number of ways to do this. A more elegant solution is to have a temp table with the user's list and do a join. It depends on the number of features you're looking at.

Hope this helps.

[rjbzzr400]

baavgai, on 15 Mar, 2009 - 05:31 AM, said:

Let's say I have tables that look like this:

Feature
	FeatureId
	Name

Package
	PackageId
	Name

PackageFeature
	PackageId
	FeatureId

It then becomes as simple as asking the database:

select PackageId, count(FeatureId) FeatureCount
	from PackageFeature
	where FeatureId in (2,3,4,6)
	group by PackageId
	order by count(FeatureId) desc

There are a number of ways to do this. A more elegant solution is to have a temp table with the user's list and do a join. It depends on the number of features you're looking at.

Hope this helps.

Thanks for the reply I really appreciate it , could you explain the above query a little more? What does FeatureCount relate to and what are the numbers 2,3,4,6 for? I understand each function in the query, but I don't fully understand it as a whole.
I have about 13 features in the table. Could I make a blank table with the same fields as the feature table and when the user submits the form could I insert the values (yes/no) into the new table and then do a count and join query? And if yes could you help me with that as I haven't done much with joins and the count function.

This post has been edited by rjbzzr400: 15 March 2009 - 07:32 AM