SQL Expert Needed

Hi Guys, here goes.. SELECT count(page_searchwords.word_id) as score, page_data.id, filename, title FROM page_data, pagewords, page_searchwords WHERE (page_searchwords.media_type='static' AND pagewords.id = page_searchwords.word_id AND page_data.id = page_searchwords.id AND LCASE(pagewords.wo

RE: Count(*) with zero rows

Hi Raymond, I have been having the same problem using the GROUP BY statement, even without the COUNT(*) function. I'm working with PHP and the way I got around this is to use arrays. I retrieved all rows from the table and then sorted them into seperate arrays according to, in your case, ClientN

My SELECT is still returning the same rows

ll returning the same rows. As in, returning rows that are exactly the same? Any ideas? Thanks Scott Mebberson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: My SELECT is still returning the same rows

y, 25 September 2001 3:34 AM To: [EMAIL PROTECTED] Subject: Re: My SELECT is still returning the same rows Scott Mebberson writes: > AND (words.word LIKE '%award%' OR words.word LIKE '%section%') ## <- > difference between 1 and 2 word search What do you mean by t