Code not working?

[Chris Ginet]

Could anybody tell me if this code is correct, i get no errors but i get no output for it.

 

 

$query2 = "IF ($OK=1)  echo 'In Flight'; else  echo ARRIVE ='$ARRIVEE'";

$result2 = mysql_query($query2);

[JBS103]

What are you trying to do? What you have right now is too jumbled for me to understand. The syntax is wrong.

 

Is there a database field named OK that you want to check? From there if it is equal to 1, you want it to say is in flight, otherwise it has arrived?

[Chris Ginet]

whast it needs to do is, when the feild OK is 1 it needs to say In Flight, If if its not 1, it needs to get the vaule that is in the field $ARRIVEE

[JBS103]

You would probably do something like this if you are working with a database

<?php
//Connect to Database
$query = "Select * from TABLE"; // I don't know how many flights you have/want to change. This will do all of them. You might want to include a WHERE in the query to select only a specific flight
$result = mysql_query($query) or die(mysql_error()); //Run query
while($row = mysql_fetch_array($result)) //Loop through results
{
       if($row['OK'] == 1) //If OK is equal to one...
       {
              echo "In Flight";
       } else {
              echo $ARRIVEE;
       }
}

[warewolfe]

if ($OK=1) is always true as it is true you have just assigned the value of 1 to the variable OK. Maybe you want ($OK == 1)

 

$query2 = "IF ($OK==1) echo 'In Flight'; else  echo ARRIVE ='$ARRIVEE'";

 

$result2 = mysql_query($query2);

 

but even then $query2 doesn't look like any mysql query I've ever seen.

 

 

[Chris Ginet]

can the outcome of the IF statment be produced as a result as there is multiple records to be displayed so each record has the outcome

[Chris Ginet]

*bump*

[LazyJones]

as warewolfe already said, $query2 doesn't even slightly resemble an SQL query

[Chris Ginet]

i have changed this now to the one JBS103 kindley told me about above. That is working. How can i get it to display as a result so i can put it on a table to show it for each of the records?

[coldkill]

Hello Chris,

Haven't seen you in a while. Anywho onto the coding:

 

You need to add in table code to the echo so:

while($row = mysql_fetch_array($result)) //Loop through results
{
       if($row['OK'] == 1) //If OK is equal to one...
       {
              $row .= "<tr><td>In Flight</td></tr>";
       } else {
              $row .= '<tr><td>'.$ARRIVEE.'</td></tr>';
       }
}

echo '<table>'.$row.'</table>';

 

Mike