What's new

Closed Mysql two where conditions

Status
Not open for further replies.

daredavil07

Addict
Joined
Aug 24, 2018
Posts
63
Reaction
17
Points
86
Hello mga bossing, ano po kaya ang mali sa query ko? May search box po kasi ako, tas kailanga ko lang lahat ng results ay status='Active'.

Code:
$query = "SELECT * FROM `firm` WHERE CONCAT(`fname`, `lname`, `age`, `position`) AND (status = 'Active') LIKE '%".$valueToSearch."%'";

Salamat po!
 
Status
Not open for further replies.

Similar threads

Back
Top