Problem with an if statement

[Gareth_Morgan]

i want to display a graphic according to wether or not a value (currently_available) equals y or n in the database e.g.

if ($currently_unavailble=y)
   {
   echo "<IMG SRC=yes.jpg>";
   }
   else
   {
   echo "<IMG SRC=no.jpg>";   
} 

for some reason i cant get the code to work. any idea's?

[platinum]

Do you need to enclose the Y with quotes?

if ($currently_unavailble="y")

[Gareth_Morgan]

ive tried that and it didnt work

[platinum]

what about your = sign i'm not sure if php needs the double == or not..

[kix]

Originally posted by platinum
what about your = sign i'm not sure if php needs the double == or not..

Exactly, "=" assigns a value. "==" is a comparison operator.

so $currently_unavailable="y", sets the variable to "y". Where == will compare the contents of the variable against "y" and return a result.

Kix

[Technosailor]

thank God you jumped in there, kix... Anyways, yeah, that = needs to be ==

Way to be proactive, Gav...you'll get PHP yet.

Sketch

[platinum]

oy -- I got it right first

[Technosailor]

[Gareth_Morgan]

putting a == doesnt work either for some reason.

heres the code im using (sorry if its too much to post)

mysql_select_db("lapdancers");
  $query = "select dancerID, name, age, nationality,  picture, currently_available from dancers";
  $result = mysql_query($query);

  $num_results = mysql_num_rows($result);

  echo "<FONT SIZE=2>";

  echo "<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%>";
  echo "<TR><TD></TD><TD><FONT FACE=Verdana SIZE=2 COLOR=#1591F1>NAME</TD><TD><FONT FACE=Verdana SIZE=2 COLOR=#1591F1>AGE</TD><TD><FONT FACE=Verdana SIZE=2 COLOR=#1591F1>NATIONALITY</TD><TD></TD><TD></TD></TR>";

     echo "<TR><TD COLSPAN=7>";
     echo "<HR WIDTH=100% COLOR=#1591F1 SIZE=1>";
     echo "</TD></TR>";

  for ($i=0; $i <$num_results; $i++)
  {
     $row = mysql_fetch_array($result);
     echo "<TR>";

     echo "<TD WIDTH=20>";

if ($currently_available=="y")
    {
    echo "<IMG SRC=yes.jpg>";
    }
    else
    {
    echo "<IMG SRC=no.jpg>";
    }

     echo "</TD>";

     echo "<TD WIDTH=150><FONT SIZE=2>";
     echo stripslashes($row["name"]);
     echo "</TD><TD WIDTH=70><FONT SIZE=2>";
     echo stripslashes($row["age"]);
     echo "</TD><TD WIDTH=150><FONT SIZE=2>";
     echo stripslashes($row["nationality"]);
     echo "</TD><TD WIDTH=60><FONT SIZE=2>";
     echo "<A HREF=";
     echo stripslashes($row["picture"]);
     echo " TARGET=_blank>Picture</A>";
     echo "</TD><TD WIDTH=65><FONT SIZE=2>";
     echo "<A HREF=girls.php?dancerID=";
     echo stripslashes($row["dancerID"]);
     echo ">";
     echo "More Info</A>";

     echo "</TD></TR>";
     echo "<TR><TD COLSPAN=7>";
     echo "<HR WIDTH=100% COLOR=#1591F1 SIZE=1>";
     echo "</TD></TR>";

  }
  echo "</TR></TABLE>";

?> 

[kix]

at which point did you initialize $currently_available?
as in:

$currently_available = $row["currently_available"];

Or to something else? I don't see you setting that variable but you're using it in a comparison.

kix

[Gareth_Morgan]

thats were i screwed up, got it working now, cheers guys