I'm using the following query:
Code:
    $sql = mysql_query("SELECT fi.fname, fi.comment, fi.ftime, fo.foname
                        FROM files as fi, folders as fo
                        WHERE fi.ffolder = foid AND fi.fname LIKE '%".$searchstring."%'
                        #OR fi.comment LIKE '%".$searchstring."%'
                        ORDER BY fo.foname, fi.fname") or die(mysql_error());
The line that is commented out is causing me loads of problems! What I need to do is select files where fi.ffolder = foid and where either the filename (fi.fname) or comment (fi.comment) is like the search string

Any thoughts?

Sean