Multiple Search Criteria

Hamsterpants

Hi All,

I am wanting to offer a number of drop down boxes (5), allowing user to select any combo of them or all etc. I have spent alot of time reading to try and find out what I have doen wrong, but because I am a newbie to both PHP and SQL, I am struggling to find where I am going wrong. I would really appreciate it if someone could have a look over my code below and tell me where I am going wrong. The code I have listed only inlcludes two search criteria, but I am sure that if I can get that to work, I can get 5 to work.

Thnaks in advance
Hamsterpants

<?php require_once('Connections/connEMI.php'); ?>
<?php
$maxRows_results = 10;
$pageNum_results = 0;
if (isset($HTTP_GET_VARS['pageNum_results'])) {
$pageNum_results = $HTTP_GET_VARS['pageNum_results'];
}
$startRow_results = $pageNum_results * $maxRows_results;

$colname_results = "USA";
if (isset($HTTP_GET_VARS['Country'])) {
$colname_results = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['Country'] : addslashes($HTTP_GET_VARS['Country']);
}
$colname_results = "Pop";
if (isset($HTTP_GET_VARS['Country'])) {
$colname_results = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['Country'] : addslashes($HTTP_GET_VARS['Country']);
}
mysql_select_db($database_connEMI, $connEMI);
$query_results = sprintf("SELECT * FROM web_data WHERE Country = '%s' and Genre = '%s'", $colname_results,$colname_results);
$query_limit_results = sprintf("%s LIMIT %d, %d", $query_results, $startRow_results, $maxRows_results);
$results = mysql_query($query_limit_results, $connEMI) or die(mysql_error());
$row_results = mysql_fetch_assoc($results);

if (isset($HTTP_GET_VARS['totalRows_results'])) {
$totalRows_results = $HTTP_GET_VARS['totalRows_results'];
} else {
$all_results = mysql_query($query_results);
$totalRows_results = mysql_num_rows($all_results);
}
$totalPages_results = ceil($totalRows_results/$maxRows_results)-1;
?>
<html>
<head>
</head>

sijis

Maybe try to simplify it.

this might/might not work, just a working thought
this isn't complete and you will have to change the table name and limit values in the queries.
it would have been more complete, but i didn't a few things.

<?php require_once('Connections/connEMI.php'); ?> 
<?php
$maxRows_results = 10; 
$pageNum_results = 0;

if (isset($HTTP_GET_VARS['pageNum_results'])) { 
	$pageNum_results = $HTTP_GET_VARS['pageNum_results']; 
} 
$startRow_results = $pageNum_results * $maxRows_results; 

switch($colname_results){
	case "USA";
		$SQLquery = "SELECT * FROM table WHERE Country = 'USA' LIMIT $foo, $bar";
	break;
	case "Pop";
		$SQLquery = "SELECT * FROM table WHERE Genre = 'Pop' LIMIT $foo, $bar";
	break;
	default; // if user selects "All"
		$SQLquery = "SELECT * FROM table LIMIT $foo, $bar";
}
mysql_select_db($database_connEMI, $connEMI); 
$results = mysql_query($SQLquery, $connEMI) or die(mysql_error()); 
$totalPages_results = ceil($totalRows_results/$maxRows_results)-1; 
?>
<html> 
<head></head> 
<body> 
<?php 
// i did a while loop just in case the search
// doesn't match anything, then you would
// possibly get an error.
	while($row_results = mysql_fetch_assoc($results))
		echo $row_results['Title'];
}
?> 
</body> 
</html> 
<?php 
mysql_free_result($results); 
?>

hope this helps and gives you an idea.