Ayuda con un query usando where, and /or , like

[huesos52]

Si te entendí bien, prueba esto:

Código mysql:

SELECT l.parentdir, l.name, l.approved, l.description, c.id as catid, c.level as catlevel, c.name as catname 
    FROM Links l, Categories c 
    WHERE l.parentdir = c.id and l.approved=1 and (l.description like '%" . $name . "%' or 
l.name like '%" . $name . "%');
 

Un saludo.