Topic: Building search for MySQL and need help with Query

[$username]

Hello Everyone,
    I am trying to build a query to search my tables. What I am getting is it will find all of the info from all fields  and then when I out put it in PHP it will show up as many times as it found it in the same table field.

So here is example
First Name | LastName | email|
Timmy       | Billy         | timmy@gmail.com
__________________
So when I search it shows the same search 2 times
I need to know if there is a way to restrict the search so it does not show 1 column 2 times when it searches? Or is this something I have to do in PHP?

Code: [Select]

$query213 = "SELECT * FROM `tdb_` . `contacts`, `tdb_` . `account` WHERE ( contacts.ContactFname LIKE
CONVERT( _utf8 '%$trimmed%' USING latin1 ) COLLATE latin1_swedish_ci OR contacts.ContactLname LIKE
CONVERT( _utf8 '%$trimmed%' USING latin1 ) COLLATE latin1_swedish_ci OR contacts.ContactPhone LIKE)"


Thanks for any help
Brett

[fenway]

That's because you have no join condition between those 2 tables ... has nothing to do with the "searching" perse.