PHP Error

[SimMiles]

Hello I am getting the following php Error



<?
$type=$_POST['type'];
if($type=="PASS/ARR"){
$arr_dep="ARR";
$cargo_pass="PASS";
}
if($type=="PASS/DEP"){
$arr_dep="DEP";
$cargo_pass="PASS";
}
if($type=="CARGO/ARR"){
$arr_dep="ARR";
$cargo_pass="CARGO";
}
if($type=="CARGO/DEP"){
$arr_dep="DEP";
$cargo_pass="PASS";
}
$db_host="***************";
$db_user="**************";
$db_pwd="**********";
$db_name="************";

$db = mysql_connect ($db_host, $db_user, $db_pwd) or die ("Impossibile connettersi al DB");
mysql_connect ($db_host, $db_user, $db_pwd) or die ("Impossibile connettersi al DB");
mysql_select_db ($db_name, $db) or die ("Impossibile selezionare il DB");
$query = " SELECT * FROM `sia` WHERE `arr_dep`='$arr_dep' , `cargo_pass`='$cargo_pass' ";
$result = mysql_query ($query, $db)or die('Error in query: '.mysql_error());
while ($line = mysql_fetch_array ($result, MYSQL_ASSOC))
{
?>

<tr height="30">

<td><div align="center" class="style1"><b> <img style="margin-left:1px; " src="http://www.simmiles.com/asiava/SIA/logo/<? echo $line['airline_icao'] ?>.gif" alt="Logo Not Found"/>

</b></div></td>

<td><div align="center"><? echo $line['dep_icao']; ?></div></td>

<td ><div align="center"><? echo $line['arr_icao']; ?></div></td>
<td><div align="center"><? echo $line['dep_time']; ?></div></td>
<td ><div align="center"><? echo $line['arr_time']; ?></div></td>
<td><div align="center"><? echo $line['flight']; ?></div></td>
<td ><div align="center"><? echo $line['aircraft']; ?></div></td>
<td><div align="center"><? echo $line['airline_name']; ?></div></td>

<?
$avaible=$line['avaible'];
if ($avaible=="YES"){ ?>



<td><div align="left" class="style1"><b> <a href="book_flight.php?id=<? echo $line['id'] ?>" >Book</a> </b></div></td>


<?
}else{


?>



<td><div align="left" class="style1"><i> Booked</i></div></td>

<?

}
?>






<?
}
?>
</table>

<br />




I get the following error
Error in query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `cargo_pass`='PASS'' at line 1
Any Ideas?

I tried takeing out MYSQL_ASSOC But it did not work. I tried taking out `arr_dep`='$arr_dep' OR `cargo_pass`='$cargo_pass' and i works. What can I do next. I need both in there.

[forum_amnesiac]

Your problem is in this line, you are trying to select records if 2 fields match a value, this is called a conditional query and as such you need to use conditional operators


$query = " SELECT * FROM `sia` WHERE `arr_dep`='$arr_dep' , `cargo_pass`='$cargo_pass' ";

Change the line to this


$query = " SELECT * FROM `sia` WHERE `arr_dep`='$arr_dep' && `cargo_pass`='$cargo_pass' ";
A comma is not a conditional operator, you can use the comma as part of the ORDER BY part of a query to order by 2 or more fields.