checking values in database.......
Posted: Wed Feb 12, 2003 9:27 am
Not the most descriptive topic title, and for that I apologise;
here's my problem - I just started back playing with php again - having not done anything for almost 9 months.......
Anyway, I have a table in my database where people put in either a 1,2 or an X into each of the 6 columns - what I've suddenly got stuck on is I want to check these 6 items against another 6 from a different table and produce a different result based on whether 2, 3, 4, 5 or 6 of the items matching up and I've got absolutely no idea how to do this, so can one of you fine people please help me out or give me a push in the right direction? Thanks.
here's my problem - I just started back playing with php again - having not done anything for almost 9 months.......
Anyway, I have a table in my database where people put in either a 1,2 or an X into each of the 6 columns - what I've suddenly got stuck on is I want to check these 6 items against another 6 from a different table and produce a different result based on whether 2, 3, 4, 5 or 6 of the items matching up and I've got absolutely no idea how to do this, so can one of you fine people please help me out or give me a push in the right direction? Thanks.