Hello,
I was going to post the full script but don't think it will ne needed.
Basically i have this query:
// query db
$query = mysql_query("SELECT * FROM `userinformation` WHERE `username` LIKE '%$search%' OR `email` LIKE '%$search%' OR
`id` LIKE '%$search%' OR `first_name` LIKE '%$search%' OR `last_name` LIKE '%$search%' ORDER BY id ASC") or die(mysql_error());
Now when i do a search for example ja in phpmyadmin it gives me 4 results as 4 people have a username that begins with ja yet my query on my search form above only brings back one result.
The query in phpmyadmin goes like:
SELECT *
FROM `userinformation`
WHERE `username` LIKE '%ja%'
I have tried numerous ways with no luck. apart from the additional OR the query is the same yet it only gives on result. I tried removing the or(s) althou that suppose to obviously give back more results based on the LIKE in the query.
Does anyone know what could be causing it to only give one result?
Any help much appreciated as always.
Thanks.