[Resolved] Problem with coding this script -- please help :)

brailleschool

Just gone through 910 posts on this forum looking for the answer to my question and havent found it.

I am trying to write an advanced search form. The form itself has six drop down menus. Depending on the value of EACH drop down, it will only show the mysql entries with all these values.

For example:
If I search for entries that contain the following criteria:
$country = USA
$age = 28
$iam = Sighted
$gender = Female
$status = Married
$account_active = Yes

Then it will only show a listing of members who are from the USA, are 28 years old, are sighted, are female, married, and who are online ($account_active = Yes)

However, when I click the search button, I am presented with an error of "No matches were found in the member database for the selected criteria." (This happens regardless of what values I select from the drop downs.)

Can you please look over my code and tell me where I am going wrong? Thanks in advance.

I had to attach the code as I could not add it here because of the length of code.

devinemke

basic debugging:

your code assumes register_globals in on...is it?
why are you passing all those (empty) GET vars in your action tag? your form is POST method.
use print_r($_POST) to see what exactly your form is returning
echo your query before running it to see if it looks OK
use [man]mysql_errror[/man] to see what (if any) errors mySQL is spitting out

brailleschool

changed method=post to method=get and this is what I get:

Address Bar:
[url]http://www.*******.net/advsearchusers.php?country=USA&age=28&iam=Blind&gender=Male&status=Married&account_active=Yes[/url]

I echo the $query and get this:
SELECT * FROM login WHERE (country LIKE 'USA' AND age LIKE '28' AND iam LIKE 'Blind' AND gender LIKE 'Male' AND status LIKE 'Married' AND account_active LIKE 'Yes') order by username ASC

But still get no results displayed.

devinemke

Originally posted by brailleschool
i dont understand

can you be more specific?

brailleschool

I got the search form working. I tried many different things and it worked the way it should.

Attached is the working code if anyone wants to use it/modify it. (next post)

devinemke

let's back up here. change your action tag to:

<form action="advsearchusers.php" method="post">

then change you PHP form handler to:

<?php
include('config.php');
$connection = mysql_connect($server, $db_user, $db_pass) or exit(mysql_error());
$db = mysql_select_db($database, $connection) or exit(mysql_error());

$magic_quotes = get_magic_quotes_gpc();
foreach ($_POST as $key => $value)
{
	if (!$magic_quotes) {$value = addslashes($value);}
	$sql[] = $key . " LIKE '%$value%'";
}
$query = 'SELECT * FROM login WHERE ' . implode(' AND ', $sql) . ' ORDER BY username';
$result = mysql_query($query, $connection) or exit(mysql_error());

if (!mysql_numrows($result))
{
	echo 'No matches were found in the member database for the selected criteria.';
}
else
{
	while ($row = mysql_fetch_assoc($result))
	{
		foreach ($row as $key => $value)
		{
			echo $key . ' = ' . $value . '<br>';
		}
		echo '<br>';
	}	
}
?>

brailleschool

the code works (attached)

robert_w_ark

Check your $rows array.

echo "<tr><td>Country:</td><td>$rows[country]</td></tr><tr><td>Age:</td><td>$rows[age]</td></tr><tr><td>Member Is:</td><td>$rows[iam]</td></tr><tr><td>Gender:</td><td>$rows[gender]</td></tr><tr><td>Marital Status:</td><td>$rows[status]</td></tr><tr><td>Member Online:</td><td>$rows[account_active]</td></tr>";

that should be this..

echo "<tr><td>Country:</td><td>$rows['country']</td></tr><tr><td>Age:</td><td>$rows['age']</td></tr><tr><td>Member Is:</td><td>$rows['iam']</td></tr><tr><td>Gender:</td><td>$rows['gender']</td></tr><tr><td>Marital Status:</td><td>$rows['status']</td></tr><tr><td>Member Online:</td><td>$rows['account_active']</td></tr>";