I have in database two information that matches with the names and the address. Instead of returning 2, this code is returning 21. Please see below;
$select = mysql_query("
WHERE name LIKE '%John%'
OR name LIKE '%Johanson%'
AND address='Streetford End'
$count = mysql_num_rows($select);
This might be helpful:
SELECT * FROM employees WHERE (name LIKE '%John%' OR name LIKE '%Johanson%') AND address='Streetford End'