PHP - Elseif

Hi Guys,

I'm not sure what to do here. I have a variable that is passed on via a url. I have a database table that has a field called 'publish'. This field contains either a Yes or a No.
All I want to do is check the field an if it is Yes then make it No, and likewise if it is No then make it Yes.
Here is my code. It changes one way but not the other. The value of $publish seems to stay the same...please help...Thank you.

Code: [Select]
<?php

 // connect to the database
 include('connect-db.php');

 // get id value
$id = $_GET['id'];
echo "$id";
$publish = $_GET['publish'];
echo "$publish";

 $sql="SELECT * FROM events WHERE ID='$id'";
 $result=mysql_query($sql);

if ($publish='Yes') {
   $publish=='No';
} else {
   $publish=='Yes';
}

// echo "<p>$publish</p>";

$sqltwo = "UPDATE events SET publish='$publish' WHERE ID='$id'";
$resulttwo = mysql_query($sqltwo);

// sleep(2);
// header("Location: beacon.php");

?>

hi everybody,

every time i asked a question here, i got quick and perfect answers. now i am back again with one 
i have a simple form which updates some fields in a mysql table. everything works fine, am just trying to convert numbers posted through the form into words on the update page and it is not working 
for example:
the form sends score to the update page, it is either 1, 2 or 3
all i want is that if the score on the form page was 1 then it should update the field in the table with the value "Low" if 2 then "Average" if 3 then "High"
the reason is that i dont want the user to select 1,2 or 3 and also low, average and high. so i can simply recieve 1,2 or 3 and update 2 fields at the same time.
i tried it with elseif, it doesn't work 
my code is as follows:


<?

if($_POST['Submit']){ 

$host="mysql";
$db_user="me"; 
$db_password="mypassword"; 
$database="mydb"; 
mysql_connect($host,$db_user,$db_password);
mysql_select_db($database);

$result=mysql_query("SELECT id FROM mytable ORDER BY id ASC");

while($row=mysql_fetch_assoc($result)){

$name=$_POST["name_".$row[id]];
$lastname=$_POST["lastname_".$row[id]];
$email=$_POST["email_".$row[id]];
$score=$_POST["score_".$row[id]]; // this is where i don't simply want to update the record
// with the $_POST, rather convert the number into aplhabets, i.e. 1=Low, 2=Average and 3=High


mysql_query("UPDATE mytable SET name='$name', lastname='$lastname', email='$email', score='$score' where id='$row[id]'");
}
echo "--- Update Complete ---";
}
?>

the following is the contents of my index.php file

if (isset($_GET['topic'])) {

include 'modules/pages/posts.php';

} elseif (isset($_GET['forum'])) {

include 'modules/pages/topics.php';

} elseif (isset($_GET['parent'])) {

include 'modules/pages/parents.php';

} elseif (isset($_GET['do']) == 'unanswered') {

include 'modules/pages/unanswered.php';

} elseif (isset($_GET['do']) == 'today') {

include 'modules/pages/today.php';

} else {

include 'modules/pages/forums.php';

}

as you can see depending on what the get value is it loads a corrosponding page.

however on the last 2 statements it loads the same page index.php?do=unanswered. why wont it load index.php?do=today when the $_GET value == today?

I am  a novice and had this code below working fine until I added the If / elseif to "plan_id".  Prior, the column would just list out the numbers from the database, but I want the numbers to echo out the text. Any help is appreciated.

while($row = mysql_fetch_array($result)){
    
     $bg = ($bg=='#ffffff' ? '#e7e8e8' : '#ffffff'); //For Alternate Row Colors
   
   echo '<tr bgcolor="' . $bg . '"><td>' . $row['customers_firstname'] . " " . $row['customers_lastname'] . '</td><td>' . date("M. d, Y", strtotime($row['date'])) . '</td><td>' . if ($row['plan_id'] == 1) {
   echo "1 DVD";
   }
   elseif ($row['plan_id'] == 2) {
   echo "2 DVDs";
   }
   else {
   echo "3 DVDs";
   }
   . '</td></tr>';}
      echo '</table>';
      echo '<br />';

it should be pretty simple. if member type == Gold or silver echo from a
if $member== client echo form b.

the query is working as i can echo out $member and display the member type before the if statement.
after the if statement no variables will echo out.

Gold is with a capital G and silver is not in the database.

Code: [Select]
$data=mysql_query(" SELECT * FROM members WHERE email='$myusername' and password='$mypassword'")or die (mysql_error());
while ($info=mysql_fetch_array($data)){
 
 $member=$info['member_type'];
 $email=$info['email'];
 $frist=$info['fname'];
 $last=$info['lname'];
 $country=$info['country'];
 $add=$info['address'];
 $state=$info['state'];
 $zip=$info['zip'];
 
 }
 
  echo $member;
  echo $frist;
 ?>
 

 
 <html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
<title>3designbreif.com | Create profile</title> 
<link rel="stylesheet" type="text/css" href="../css/3lance.css" media="all" />
</head> 
<body> 
 
<div class="content" style="background-image:url(../img/3lancecreatep.png);">
 <div id="update">
 <?php 
 echo "welcome ".$email." Please Change your password and comfirm details.";
 echo "<br/>";
 ?>
<?php
if($member=='Gold' || $member=='silver'){
?>
<form action="../php/update.php" method="post">

<div style="clear:both;"></div>

<label for='password'>Password</label><input type="password" name="password" />
<div style="clear:both;"></div>
<label for='password2'>Comfirm Password</label><input type="password" name="password2" />
<div style="clear:both;"></div>
<label for="name">Name</label><input type="text" name="name" value="<?php $frist?>"/>
<div style="clear:both;"></div>
<label for="lname">Last Name</label><input type="text" name="lname" value="<?php $last?>" />
<div style="clear:both;"></div>
<label for="address">Address</label><input type="text" name="address" value="<?php $add?>" />
<div style="clear:both;"></div>
<label for="state">State</label><input type="text" name="state" value="<?php $state?>" />
<div style="clear:both;"></div>
<label for="country">Country</label><input type="text" name="country" value="<?php $country?>" />
<div style="clear:both;"></div>
<label for="zip">Zip</label><input type="text" name="zip"value="<?php $zip?>" />
<div style="clear:both;"></div>

<?php
}

if($member=='client'){
echo $member;
?>

<form action="../php/update2.php" method="post">

<div style="clear:both;"></div>

<label for="password">Password</label><input type="password" name="password" />
<div style="clear:both;"></div>
<label for="password2">Comfirm Password</label><input type="password" name="password2" />
<div style="clear:both;"></div>
<label for="name">Name</label><input type="text" name="name" value="<?php echo $frist;?>" />
<div style="clear:both;"></div>
<label for="lname">Last Name</label><input type="text" name="lname" value="<?php echo $last;?>" />
<div style="clear:both;"></div>
<label for="address">Address</label><input type="text" name="address" value="<?php echo $add;?>" />
<div style="clear:both;"></div>
<label for="state">State</label><input type="text" name="state" value="<?php echo $state;?>" />
<div style="clear:both;"></div>
<label for="country">Country</label><input type="text" name="country" value="<?php echo $country;?>" />
<div style="clear:both;"></div>
<label for="zip">Zip</label><input type="text" name="zip"value="<?php echo $zip;?>" />
<div style="clear:both;"></div>

<?php
}
?>