OR problem

[seanf]

I'm using the following query:

    $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

[DR_LaRRY_PEpPeR]

try this:

$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());

precedence thing with AND/OR. parentheses should fix that.

[seanf]

Matt I could kiss you!

The stupid thing is I actually thought about trying that and then completely forgot :slaps head:

Thank you

Sean

[DR_LaRRY_PEpPeR]

great.