My limited knowledge expected a simple query to work:
Code: Select all
mysql_select_db($database_ml, $ml);
$query_reviews2 = ("SELECT * FROM ap_form_2 WHERE element_3 LIKE '$_GET[element_3]'");
$reviews2 = mysql_query($query_reviews2, $ml) or die(mysql_error());
$row_reviews2 = mysql_fetch_assoc($reviews2);
$totalRows_reviews2 = mysql_num_rows($reviews2);It looks like I'm going to have to use "EXPLODE" to get all the words into and array and then query. I found this suggestion on the web:
Code: Select all
$array = explode(' ', $_GET[element_3]);
$query = 'SELECT * FROM ap_form_2 WHERE ';
foreach($array as $in)
$query .= 'element_3 LIKE "%'.$in.'%" OR ';
mysql_query($query.'0');Any direction would be appreciated!!! Thanks again!
Metal-X