I need to make my two search options, “female workout buddy” & “Male workout buddy” searchable for members. Right now if someone is looking for a female or male workout buddy no results will display. The majority of the girls on my site are just looking for a female workout buddy so all of them should show in the results.


Here is the thread to the forum post that explained to me how to do this:http://forum.tufat.com/showthread.php?t=40567


Here's my post: http://forum.tufat.com/showthread.php?t=43727


I attached screen shots. I added the entries as directed by the makes of the script i'm using into the lang_main.php file. I attached a screen shot of it. They are entries "W" (for Female workout buddy), and "X" (for Male workout buddy).

They only gave me instructions to modify these 3 php files (mymatches.php, searchmatches.php, and lang_main.php). Do I need to modify anything in MySQL databse to make this work?



Please help!

Ok, ppl look at this as if i'm just adding a search option to my website for a product, its the same thing. Does anyone know how to do that w/ php, and mySQL?

Just make a combo box and then query based on that.

PHP Code:

<?php if (isset($_GET['Search']))
{
$result = mysql_query("SELECT * FROM database WHERE gender='$_GET[\"partners\"]'") or die(mysql_error());
while($row = mysql_fetch_array($result))
{
echo $row['name']
}
?>
<form action="THISPAGE.php" method="get">
<select name="partners">
<option value="f">Female</option>
<option value="m">Male</option>
</select>
<input type="submit" name="search" value="Find Buddy">
</form>

Im sure there a few errors in what I just wrote but something to that affect.

Thanx truly, I got it to work, but I don't like how I had to do it. I'll try your way.