syntax help

[dflow]

i would like to create an if else conditional

what is the correct way to echo such code?

<?php
$CityID=$_GET['CityID'];
if ($CityID<>"")
  {
  $colname_RsCityProductLoop = "-1";
if (isset($_GET['CityID'])) {
  $colname_RsCityProductLoop = $_GET['CityID'];
}
mysql_select_db($database_international, $international);
$query_RsCityProductLoop = sprintf("SELECT products_NEW.ProductID, city_list.CityName_heb, products_NEW.Sleeps, products_NEW.Num_Bed_Rooms, products_NEW.Num_bathroom, products_NEW.kitchen_details, products_NEW.Parking_Space, products_NEW.Elevator, products_NEW.Floor, products_NEW.ProductImage_1, products_NEW.ShortProductDescription_heb,products_NEW.UnitPrice FROM products_NEW, city_list WHERE city_list.CityID =%s AND products_NEW.CityID =%s AND products_NEW.LangHEB =1 ORDER BY RAND( )", GetSQLValueString($colname_RsCityProductLoop, "int"),GetSQLValueString($colname_RsCityProductLoop, "int"));
$query_limit_RsCityProductLoop = sprintf("%s LIMIT %d, %d", $query_RsCityProductLoop, $startRow_RsCityProductLoop, $maxRows_RsCityProductLoop);
$RsCityProductLoop = mysql_query($query_limit_RsCityProductLoop, $international) or die(mysql_error());
$row_RsCityProductLoop = mysql_fetch_assoc($RsCityProductLoop);
  }


else
$CityName=$_GET['CityName'];
  {
  $colname_RsCityProductLoop = "-1";
if (isset($_GET['CityName'])) {
  $colname_RsCityProductLoop = $_GET['CityName'];
}
mysql_select_db($database_international, $international);
$query_RsCityProductLoop = sprintf("SELECT products_NEW.ProductID, city_list.CityName_heb, products_NEW.Sleeps, products_NEW.Num_Bed_Rooms, products_NEW.Num_bathroom, products_NEW.kitchen_details, products_NEW.Parking_Space, products_NEW.Elevator, products_NEW.Floor, products_NEW.ProductImage_1, products_NEW.ShortProductDescription_heb,products_NEW.UnitPrice FROM products_NEW, city_list WHERE city_list.CityName=%s AND city_list.CityID=products_NEW.CityID  AND products_NEW.LangHEB =1 ORDER BY RAND( )", GetSQLValueString($colname_RsCityProductLoop, "int"),GetSQLValueString($colname_RsCityProductLoop, "text"));
$query_limit_RsCityProductLoop = sprintf("%s LIMIT %d, %d", $query_RsCityProductLoop, $startRow_RsCityProductLoop, $maxRows_RsCityProductLoop);
$RsCityProductLoop = mysql_query($query_limit_RsCityProductLoop, $international) or die(mysql_error());
$row_RsCityProductLoop = mysql_fetch_assoc($RsCityProductLoop);
  }
?>

 

 

[trq]

if ($expression) {
  // do something
} else {
  // do something else
}

[dflow]

thanks it cleared things up