PHP - Comparison Issues. (if Statement)

Hi guys

I was just wondering if there is some date combination for which this type of comparisons will not work.

var_dump("2010-15-1">"2010-4-01");

Provided the date is always in the YYYY-mm-dd format with optional preceding 0 .

Thanks

It DOES NOT any of this information for the wrestlers that DO NOT have a manager and if they do then it shows all as undefined variables. I know it has to do with the while statement I'm sure it's how its echoing the info and I don't know how to modify it so that I can echo the variable and if there's no value for the row then it shows N/A as its value.


function getWrestling($style, $id) {
$id=mysql_real_escape_string($id);
if ($style=='singles') { 
$query = "SELECT bio.charactername AS manager, ebw.finisher AS finisher, ebw.setup AS setup, ebw.music AS music FROM efed_bio_wrestling AS ebw JOIN efed_bio AS bio ON ( ebw.manager_id = bio.id) WHERE ebw.bio_id = '$id'";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)){
?>
<h2>Wrestling</h2>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowb">
<td class="biotableheadingb">Manager/Valet:</td>
<td class="biotabledatab"><?php if (strlen ($manager) < 1) {  print "N/A"; } else { print "$manager";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Finisher:</td>
<td class="biotabledatab"><?php if (strlen ($finisher) < 1) {  print "N/A"; } else { print "$finisher";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Setup:</td>
<td class="biotabledatab"><?php if (strlen ($setup) < 1) {  print "N/A"; } else { print "$setup";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Entrance Music:</td>
<td class="biotabledatab"><?php if (strlen ($music) < 1) {  print "N/A"; } else { print "$music";}?></td>
</tr>
</table>
<?php } }?>

Ok, i am adding a few things onto a "php email form" script, everything works as it should apart from this.

The php email form, catches the submitted data and emails it accordingly, then after that, i use some of the data and show it, one form value i would like to show is from a radio button. Theres two radio buttons in one group.

The radio buttons group name is "postage", value1 = "first" value2 = "second".

$post1 is one cost, and $post2 is another cost, both get submitted an received fine.

And as it stands when i submit the form without the line below, and tell it to echo "postage", it works fine. IF though i add this line after:

if ($postage = "first") {$post_cost = $post1;} elseif ($postage = "second") {$post_cost = $post2;}
If simply just comes threw as "first" everytime regardless, Why??
Heres the code for this section:
//Collect postage details
if(isset($_REQUEST['postage'])){$postage = stripslashes($_REQUEST['postage']);}
if(isset($_REQUEST['post1']) && !empty($_REQUEST['post1'])){$post1 = stripslashes($_REQUEST['post1']);}
if(isset($_REQUEST['post2']) && !empty($_REQUEST['post2'])){$post2 = stripslashes($_REQUEST['post2']);}
if(isset($_REQUEST['Total:']) && !empty($_REQUEST['Total:'])){$total = stripslashes($_REQUEST['Total:']);}

//Get disired postage type
$post_cost = 0;
if ($postage = "first") {$post_cost = $post1;} elseif ($postage = "second") {$post_cost = $post2;}

//Work out total to pay
$totaltopay = $total+$post_cost;
?> 
Thanks
Andy

Am trying to redirect a user based on their login details. it works fine till it get to a particular department.. "Marine Logistics". when i try to log in with ID of someone in that department, it redirects to invalid login page. the code below. what am i missing?     $sql1 = mysql_query("SELECT * FROM users WHERE username = '$username' AND password = '$password'");
        $data = mysql_fetch_array($sql1);
        
        $department = $data['department'];
        
         if ($department== "Admin")
  {
  header("Location: admin/dash_admin.php");
  exit;
  }
 
   else if ($department == "ICT" )
  {
      if ($data['position'] == "HOD")
      {
        header("Location: ICT/HOD/hod_dash.php");
          exit;
      }
      
      else{
          
            header("Location: ICT/staff/staff_dash.php");
      exit;
    }
    exit;
  }
  // check if user is in account department
  else if ($department == "Account" )
  {
      if ($data['position'] == "HOD")
      {
        header("Location: account/HOD/account_dash.php");
          exit;
      }
      else
      {
          
            header("Location: account/staff/staff_dash.php");
      exit;
    }
    exit;
  }
 
  //check if user is in Supply chain/ Asset Integrity department
    else if ($department == "Supply Chain/ Asset Integrity" )
  {
      if ($data['position'] == "HOD")
      {
        header("Location: supply_chain/HOD/hod_dash.php");
          exit;
      }
      else{
          
            header("Location: supply_chain/staff/staff_dash.php");
      exit;
    }
    exit;
  }

// check if user is in manpower department

    else if ($department == "Manpower" )
  {
      if ($data['position'] == "HOD")
      {
        header("Location: manpower/HOD/hod_dash.php");
          exit;
      }
      else{
          
            header("Location: manpower/staff/staff_dash.php");
      exit;
    }
    exit;
  }
 
  // check if user is in Business Development Department
 
      else if ($department == "Business Development" )
  {
      if ($data['position'] == "HOD")
      {
        header("Location: business_development/HOD/hod_dash.php");
          exit;
      }
      else{
          
            header("Location: business_development/staff/staff_dash.php");
      exit;
    }
    exit;
  }
 
  // check if user is in HR
 
   else if ($department == "HR" )
  {
      if ($data['position'] == "HOD")
      {
        header("Location: HR/HOD/hod_dash.php");
          exit;
      }
      else{
          
            header("Location: HR/staff/staff_dash.php");
      exit;
    }
    exit;
  }
 
  //check if user is in Marine Logistics Department
 
   else if ($department== "Marine Logistics" )
  {
      if ($data['position'] == "HOD")
      {
        header("Location: logistics/HOD/hod_dash.php");
          exit;
      }
      else{
          
            header("Location: logistics/staff/staff_dash.php");
      exit;
    }
    exit;
  }
 
  //check if user is from Maintenance Department
 
  else if ($department == "Maintenance" )
  {
      if ($data['position'] == "HOD")
      {
        header("Location: Maintenance/HOD/hod_dash.php");
          exit;
      }
      else{
          
            header("Location: Maintenance/staff/staff_dash.php");
      exit;
    }
    exit;
  }
 
   //check if user is from Admin/services Department
 
  else if ($department == "Admin / Services" )
  {
      if ($data['position'] == "HOD")
      {
        header("Location: admin_services/HOD/hod_dash.php");
          exit;
      }
      else{
          
            header("Location: admin_services/staff/staff_dash.php");
      exit;
    }
    exit;
  }


    }
    else{
        header("Location: indexWrongPassOrUser.php");
        exit;
    }
 

Hi, I'm having a slight issue with some coding (see below). It worked a few minutes ago before I add "Packages" & "Safety & Technology" titles to the MySQL database.

Hopefully the attached image has worked, but if it hasn't go to www.bikescarsandvans.co.uk/test.php and select the first Audi A3 additional extras drop down menu and you'll see whats going wrong.

Code: [Select]
$query_title = "SELECT * FROM extras JOIN car_to_extra ON (car_to_extra.extras_id = extras.id) WHERE car_to_extra.car_id = '{$car_row['id']}' ORDER BY extras.price ASC";
$title_results = mysql_query($query_title) or die ("Error in query: $query_title. ".mysql_error());
$current_heading = '';
print "<div class='addtional_extras'>";// ADDED TO TRY TO SORT OUT POSITIONING ISSUE
while ($title_row = @ mysql_fetch_array($title_results ))
{
if ($current_heading != $title_row["title"])
{
    // The heading has changed from before, so print the new heading here.
    $current_heading = $title_row["title"];
    print "



<div class='title_tab2'>" . $title_row["title"] . "</div>
  ";
  }

  ?>
                                           
                                            <a class='data' href='#' onmouseout='hideTooltip()' onmouseover='showTooltip(event,"<?php print "" . $title_row["info"] . "<br/>(&pound;" . $title_row["price"] . ")"; ?>");return false'>
                                      <?php
print "
<img class='extra_img' src=\"". $title_row["img"] ."\" alt='" . $title_row["img_alt"] . "' /></a>


";

}// CLOSES WHILE LOOP ($title_row = @ mysql_fetch_array($title_results )) 
print "</div>";// CLOSES DIV IMAGE55