PHP/MYSQL Query Problem

Anon

Here is my problem.

I have the following fields in a database that are related to the problem.

fname (users first name)
lname (users last name)
pickf (another users first name)
pickl (another users last name)

See a client wants to make a niche dating system where someone enters a first name(pickf) and last name(pickl) of someone else.

Now if that person that he picked put his first name in pickf and his last name in pickl, I need a script that will say that he has a match.

That is kind of confusing.. here is another explanation.

Bob logs on to the web site and registers under the name: Bob Doe(fname=Bob and lname=Doe). He then logs in and types in Jane for the field pickf and Doe for the field pickl.

1 week later....

Jane Doe registers for service. (fname=Jane and lname=Doe). She then types in Bob for the field pickf and Doe for the field pickl.

Now both people technically entered the other persons name.

I am in need for a script to check to see if Bob Doe's pickf/pickl is the name of someone that has their pickf and pickl Bob Doe.

Please help me on this.

I am only looking for the query or lines of code.

I know php fairly well but I am stuck on this.

staffanolin

the query could look something like this:
$search= mysql_query("SELECT * FROM DataBase WHERE fname='$pickf' AND lname='$pickl'");

then,
while($result = mysql_fetch_array($search))
{
print($result["fname"]." ".$result["lname"]."\n");
}

the query returns all rows in the database with the exact match for fname and lname.
The while-loop prints each person's firstname and lastname.

Id you don't want exact matches, you can use "LIKE" instead.
Ex:
$search= mysql_query("SELECT * FROM DataBase WHERE fname LIKE '%$pickf%' AND lname LIKE '%pickl%'");

this will return all that contains the words in for example $pickf.
Ie. if you $pickf == "anna"
the name "johanna" will be returned too, as will "hanna", but not johan.

I hope you understand what I mean with this. If not, just let me know 😉..

/Staffan