easiest way for advance search
Posted: Tue Mar 13, 2007 8:35 pm
whats the easiest way to do this advance search feature. i kind of messed it up =(
http://www.phpldtemplates.org/advance_search.php
Heres what i have now and its limited. i want to be able to search for all tags selected. not exact input of the tags selected.
http://www.phpldtemplates.org/advance_search.php
Heres what i have now and its limited. i want to be able to search for all tags selected. not exact input of the tags selected.
Code: Select all
$result = mysql_query("SELECT id,screen_url, name FROM themes WHERE
column1='" . $tags[0] . "' AND
column2='" . $tags[1] . "' AND
column3='" . $tags[2] . "' AND
mixed='" . $tags[3] . "' AND
white='" . $tags[4] . "' AND
yellow='" . $tags[5] . "' AND
grey='" . $tags[6] . "' AND
pink='" . $tags[7] . "' AND
red='" . $tags[8] . "' AND
orange='" . $tags[9] . "' AND
blue='" . $tags[10] . "' AND
green='" . $tags[11] . "' AND
purple='" . $tags[12] . "' AND
brown='" . $tags[13] . "' AND
black='" . $tags[14] . "' AND
left_sidebar='" . $tags[15] . "' AND
right_sidebar='" . $tags[16] . "' AND
adsense_ready='" . $tags[17] . "' AND
no_images='" . $tags[18] . "' AND
images='" . $tags[19] . "' AND
plugins='" . $tags[20] . "' AND
widget='" . $tags[21] . "' AND
fixed_width='" . $tags[22] . "' AND
fluid_width='" . $tags[23] . "' ORDER BY RAND() LIMIT 24") or die(mysql_error());