Whats wrong with this?

[UK_Steve]

I'm getting parse errors with this code, any ideas why?

$find = explode(' ', $find); 
$where = array(); 
foreach ($find as $word) { 
$word = addslashes($word); 
$where[] = "(item_name LIKE '%" . $word . "%' OR description LIKE '%" . $word . "%' )"; 
}
$mysqlsrch = "SELECT * FROM filedata WHERE ' . implode(' AND ', $where) . ' ORDER BY created DESC";

[[deleted]]

And what does the error say?

[UK_Steve]

Thanks for the reply but I figured it out.

I copied and pasted the code from another forum and it had inserted weird crucifix like symbols where ever there was a space 😕

I have gotten past the parse errors but now the query isn't getting any results from the db so I am at a loss 🙁

Can anyone here help?

I have this data

<!--music loops -->
<!--moderate piano ambient chilled out -->

in a row in mysql, what code can I use to get results for say 'moderate music loops'

At the moment I am using a mysql query which checks 2 rows like this:

$srch=$find;
$mysqlsrch = "SELECT * FROM filedata WHERE item_name LIKE '%$srch%' OR description LIKE '%$srch%' order by created desc";

This works for searchs like 'music loops' and 'moderate' but not both together?

Thanks