select distinct/search problems...

[vaska]

i'm getting really eradic results from this query...

sometimes, for words that are clearly there, i get nothing...and then it will work for some other words...i'm not sure how to really explain that...

i'm not sure what could be wrong (maybe i can't have two tables in the search? - i actually wan to add a third, but now i'm really not sure if that's a good idea)...maybe somebody knows how this could be tightened up? i'm not so great with search queries i guess...

$query = mysql_query ("SELECT DISTINCT title,text,id,pdate,templname,mainmid FROM main,templates WHERE main.mid='1' AND (main.title LIKE '%$s%' OR main.text LIKE '%$s%') GROUP BY main.id ORDER BY pdate DESC") or die ("Yo, it's not working!");

thanks...v

[sarahk]

Your query doesn't have a join in it... eg main.id = templates.mainid
and I'd take the distinct out, you are using "Group"

$sql = "SELECT title,text,id,pdate,templname,mainmid 
FROM main,templates 
WHERE main.id = templates.mainid
and main.mid='1' 
AND (main.title LIKE '%{$s}%' OR main.text LIKE '%{$s}%') 
GROUP BY main.id 
ORDER BY pdate DESC";
$query = mysql_query ($sql) or die ("Yo, it's not working!");