SQL troubles
Posted: Mon Jul 25, 2005 6:27 pm
the number of results turns out to be over 70,000 when theres really only 6 results. its giving duplicate results. any suggestions?
$sentence turns out to be
SELECT vfunk_pages.id, vfunk_pages.url, vfunk_pages.title, vfunk_pages.description, vfunk_pages.keywords, vfunk_pages.accepted, vfunk_pages.ip, vfunk_pages.category, vfunk_categories.name AS category_name FROM vfunk_pages, vfunk_categories WHERE vfunk_categories.id = vfunk_pages.category AND vfunk_pages.title LIKE '% music festival %' OR vfunk_pages.keywords LIKE '% music festival %' OR vfunk_pages.description LIKE '% music festival %' OR vfunk_pages.url LIKE '% music festival %'
code is.
$sentence turns out to be
SELECT vfunk_pages.id, vfunk_pages.url, vfunk_pages.title, vfunk_pages.description, vfunk_pages.keywords, vfunk_pages.accepted, vfunk_pages.ip, vfunk_pages.category, vfunk_categories.name AS category_name FROM vfunk_pages, vfunk_categories WHERE vfunk_categories.id = vfunk_pages.category AND vfunk_pages.title LIKE '% music festival %' OR vfunk_pages.keywords LIKE '% music festival %' OR vfunk_pages.description LIKE '% music festival %' OR vfunk_pages.url LIKE '% music festival %'
code is.
Code: Select all
$sentence = "e;SELECT {$prefix}pages.id, {$prefix}pages.url, {$prefix}pages.title, {$prefix}pages.description, {$prefix}pages.keywords, {$prefix}pages.accepted, {$prefix}pages.ip, {$prefix}pages.category, {$prefix}categories.name AS category_name FROM {$prefix}pages, {$prefix}categories WHERE {$prefix}categories.id = {$prefix}pages.category AND "e;.$sentence;
print $sentence."e;<br>"e;;
$sql = mysql_query($sentence);
$n_results = mysql_num_rows($sql);