Search Bar CONCAT query

meth8200

Hi People,

If anyone can help please?

I've got a search bar and for example im trying to search the name billy brown.

this is my query:

$query = "SELECT id, CONCAT(forename,' ',surname) AS Com

FROM contacts

WHERE CONCAT(contacts.forename = '$search' AND contacts.surname = '$search') || contacts.forename LIKE '$search%' || contacts.surname LIKE '$search%'";

The outcome to all this is that it will display the name "Billy Brown" even if i only type Billy or Brown, this works but what if someone types in the whole name "Billy Brown" no results are displayed.

Any solutions?

Thanks

CloudedVision

__________________
Take it easy

Other Road Design

WebForumz Moderator: HTML | Javascript | PHP

awatson

I think your where clause is messed up - try

WHERE contacts.forename = '$search' OR
contacts.surname = '$search' OR
CONCAT(contacts.forename, ' ', contacts.surname) = '$search'