If statement syntax help

sweeney_bob

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


********* 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']."";

  } 
// }

djjjozsi

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

count the } signs.

and in the Query, PREFIX has a defined value? becouse it has not a $ sign before.

......... FROM
".PREFIX."spieler
WHERE..............

sweeney_bob

Thanks, but where are the {} signs required usually?

djjjozsi

sweeney_bob;10891995 wrote:
Thanks, but where are the {} signs required usually?

if you want to create more then one command in an if:

if($x==1)
{
print "this is 1";

$y=2;
print " and $y is 2";
}
else
print "x is not 1";

when you use functions

function print_post($var)
{
if(isset($POST[$var]))
{
$var=mysql_real_escape_string($POST[$var]); //that will keep in safe the data posted
return $var;
}
}

and when you use while,

$sql="SELECT * FROM artickes WHERE category='".print_post("categ")."'" ;
$result=mysql_query($sql);
while($rows=mysql_fetch_assoc($result))
{
print "Title:".$rows["title"];
print "<hr>";
}