filtering database results.

[Mad_T]

Hi
I need a script that searches a database based on values entered. These entries relate to the numbers & letters on a standard phone.

So 2 is A,B & C, and 3 is D,E & F... and so on

What I need to do is look at the first digit entered and filter all entries which begin with the letters on that key.

Then examine the second digit and filter my previously filtered results to find all entries with a second letter equivalent to that key's characters. Normally, systems use the first 3 letters of a persons name only.

For example, if the user enters 272, I would need to do the following...

resultOne = An array of all the Users in the database beginning with A, B or C.
resultTwo = An array of all the Users in resultOne where the second character is P, Q, R or S.
resultThree = An array of all the Users in resultTwo where the third digit is A, B or C.

Hopefully, you should then have only 1 or 2 names in the array resultThree. You could then list these results.

Any ideas. or samples how to do this ??

Thanks 🙂

[dagon]

you don't need 3 arrays\ queries you can do this with 1 query

SELECT * WHERE (SUBSTRING('name',1) in ('a','b','c') AND SUBSTRING('name',2) in ('p','q','r','s') AND SUBSTRING('name',3) in ('a','b','b')

your a,b,c etc would be set by php, an array would be easy

$num=array('1'=>'a,b,c','2'=>'c,e,f' ... etc

[dagon]

oups my substring syntax is incorrect it should be

SUBSTRING('name',1,1)
SUBSTRING('name',2,1)
SUBSTRING('name',3,1)

SUBSTRING