Code: Select all
$query = "SELECT
user_id,
CONCAT(lastname, ', ', firstname) AS lastname,
email,
company,
position,
results,
DATE_FORMAT(timestamp, '%m/%d/%y'),
timestamp
FROM dbci_user_surveys
WHERE user_id LIKE '%$search%'
OR firstname LIKE '%$search%'
OR lastname LIKE '%$search%'
OR email LIKE '%$search%'
OR position LIKE '%$search%'
AND company = '$coco'";