Guys,

Not done much in php, could somebody help me with the syntax for this bit of code please?

Basically, if the current session alliance, alianta = "EximuS" then the filter should continue with the numele, else it should only show current alliance data.

tia
Bob


Code:
********* syntax wrong here ***

if ($_SESSION['alianta']=="EximuS") {
  $aliantaSel = $_SESSION['numele'];
else
$aliantaSel = $_SESSION['alianta'];

****************************

  if (isset($_GET['numele'])) {
  
   $sql="SELECT
            name,
            sid,
            volk,
            rechte,
            lastchange,
  alianta
          FROM
            ".PREFIX."spieler
          WHERE
            aktiv='1' AND
            alianta='".$aliantaSel."'
          ORDER BY
            ".$_SESSION['sort']."";


  } 

else {
    $sql="SELECT
              name,
              sid,
              volk,
              rechte,
              lastchange,
    alianta
            FROM
              ".PREFIX."spieler
            WHERE
              aktiv='1'
        ORDER BY
          ".$_SESSION['sort']."";

  } 
// }