Please i need help with searching criteria

[Alderan]

Well first of all i have to say i have no idea of what i did wrong but also add that i have really low php and mysql skills. Well the fact is that i was making a search form like the one in http://www.pgtour.net to make the replays of my games searchable. Well following the manuals and tutorials i found i made a code and im able to find acording to 1 criteria the rest wont work. I mean i can search by losers name for example but it wont let me by winners name.
The link to the code in actio is this: http://alderan.al.funpic.de/poop.php

MySQL_connect("localhost", "alderan", "mypass");
MySQL_select_db("alderan");
if((!$winner) || ($winner == ""))
{
$winner = "";
}
else
{
$winner = "+(".$winner.")";
}
$query = "SELECT player1, player2, races, map, MATCH(player1) AGAINST ('$winner' IN BOOLEAN MODE) AS score FROM replays
WHERE MATCH(player1) AGAINST ('$winner' IN BOOLEAN MODE)";

if((!$loser) || ($loser == ""))
{
$loser = "";
}
else
{
$loser = "+(".$loser.")";
}

$query = "SELECT player1, player2, races, map,
MATCH(player2) AGAINST ('$loser' IN BOOLEAN MODE) AS score FROM replays
WHERE MATCH(player2) AGAINST ('$loser' IN BOOLEAN MODE)";

$artm1 = MySQL_query($query);

if(!$artm1) {
echo MySQL_error()."<br>$query<br>";
}

[TobyRT]

I suggest you edit that code first and put it in

tags - it'll make it much easier for us all to read and spot any glaring typos!

[Alderan]

done

[jazz_snob]

It appears you make a query string, stuff it in $query, do nothing w/ it ( ie dont call mysql_query($query) ), then change value of $query to the 'loser' query string and then call mysql_query on that. Maybe your query string formulation inside of the if-else cases?

if( $condition_A ) {
//  $query = query for condition_A
}
if( $condition_B ) {
// $query = query for condition_B
}

$artm1 = mysql_query($query );

[Alderan]

Thx