multifield form search

[jvrothjr]

$querystring .= " WHERE venuename LIKE '%$VT%'";

 

This will find any field the contains this value

[olm75]

y is my query not bringing results....not found...i want the viewers to search using 1 or any combination of fields.....

 

 

[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--]

$querystring = \"select * from venues\";

if ($VN != \"\" AND $AC == \"\" AND $AG == \"\") {$querystring .=  \" where (venuename like \'%$VN%\')\";}

if ($VN != \"\" AND $AC != \"\" AND $AG == \"\") {$querystring .=  \" where (venuename like \'%$VN%\') AND (areacode like \'%$AC%\')\";}

if ($VN != \"\" AND $AC == \"\" AND $AG != \"\") {$querystring .=  \" where (venuename like \'%$VN%\') AND (agegroup like \'%$AG%\')\";}

if ($VN == \"\" AND $AC != \"\" AND $AG == \"\") {$querystring .=  \" where (areacode like \'%$AC%\')\";}

if ($VN == \"\" AND $AC != \"\" AND $AG != \"\") {$querystring .=  \" where (areacode like \'%$AC%\') AND (agegroup like \'%$AG%\')\";}

if ($VN == \"\" AND $AC == \"\" AND $AG != \"\") {$querystring .=  \" where (agegroup like \'%$AG%\')\";}

if ($VN == \"\" AND $AC == \"\" AND $AG == \"\") {}

[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]

[jvrothjr]

[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--]$querystring = \"select * from venues\";

if ($VN != \"\" AND $AC == \"\" AND $AG == \"\") {$querystring =  $querystring + \" where (venuename like \'%$VN%\')\";}[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]

[olm75]

ok thanks, but

do i just do that for all of the if statements or just that 1st one....

[jvrothjr]

ok thanks, but

do i just do that for all of the if statements or just that 1st one....

271773[/snapback]

 

All