daredavil07
Addict
- Joined
- Aug 24, 2018
- Posts
- 63
- Reaction
- 17
- Points
- 83
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'.
Salamat po!
Code:
$query = "SELECT * FROM `firm` WHERE CONCAT(`fname`, `lname`, `age`, `position`) AND (status = 'Active') LIKE '%".$valueToSearch."%'";
Salamat po!