[Resolved] 'switch' not working on live server

[phpdeano]

Re-posted, as originally put on Newbies forum in error.

Hi,

I have been testing the following script, which works fine on my test server.

       

$result = mysql_query($sql);
    $count = mysql_num_fields($result);
while ($rows = mysql_fetch_array($result))
       {

   switch($i)
      {
      case ($i = 2):
       if ($rows[$i] == "D")
       {$rows[$i] = "Diesel";}
       elseif ($rows[$i] != "D")
       {$rows[$i] = "Petrol";}
       break;
      }  // end


   switch($i)
      { case ($i = 12):
      if ($rows[$i] != "a")
      {$rows[$i] = "Manual";}
      else
      {$rows[$i] = "Automatic";}
      break;
      }
   switch($i)
      {
      case ($i = 5):
      if ($rows[$i] == "3")
      {$rows[$i] = "Hatchback";}
      elseif ($rows[$i] == "5")
      {$rows[$i] = "Hatchback";}
      elseif ($rows[$i] == "4")
      {$rows[$i] = "Saloon";}
      elseif ($rows[$i] == "e")
      {$rows[$i] = "Estate";}
      elseif ($rows[$i] == "c")
      {$rows[$i] = "Coupe";}

      break;
      }  // end

   switch($i)
      {
      case ($i = 6):
      if ($rows[$i] == "e")
      {$rows[$i] = "5";}
      elseif ($rows[$i] == "c")
      {$rows[$i] = "3";}
      break;
      }  // end

   switch($i)

      {case ($i = 17):
      if ($rows[$i] == ".")
      {$rows[$i] = "";}

      break;
      }  // end

//Image Check Switch
       switch($i)
          //enter image link is image exists
          {case ($i = 13):

      //determine if image exists
      $findimage = "res__".$rows[$i].".jpg";
      $dirHandle=opendir('removed path');

      while ($file = readdir($dirHandle))
      {
        if (stristr($file, $findimage))
        {
        $rows[$i] = $findimage;
        }
      }
      closedir($dirHandle);
      //end image check
      break;
      }  // end

//Second Image Check Switch
        switch($i)
          //enter image has been written
          {case ($i = 13):
          $imgchk = stristr($rows[$i],".j");

        if($imgchk != ".jpg")
        {
        $rows[$i] = "";
        }

      break;
      }  // end
//End Second Image Check
//Replace hash characters with commas
	switch($i)
	  {case ($i = 18):

  $rows[$i] = str_replace("-", ", ", $rows[$i]);
  break;
  } //end

//Enter N for new
	switch($i)
	  {case($i = 20):
	  $rows[$i] = "N";
	  break;
	  } //end

//Enter Y for used
	switch($i)
	  {case($i = 21):
	  $rows[$i] = "Y";
	  break;
	  } //end

     fwrite($handle,'"downend","",');
     for ($i=0;$i<$count;$i++){
//         echo $rows[$i];
           fwrite($handle, '"'.$rows[$i].'",');  //data
         }

     fwrite($handle,("\n"));  //new line
  }

fclose($handle);

Now testing is complete I have uploaded the script to the customers hosting account and suddenly the switch functionality will not work.

Does anyone have any ideas why?

Am I missing something really obvious?

Kind regards

[Pig]

Most likely it's a difference in the php.ini between the two servers. Probably REGISTER_GLOBALS. Is this script relying on info passed via POST, GET, etc.?

[drawmack]

Or it could be that you're using switch completely wrong

       

$result = mysql_query($sql);
    $count = mysql_num_fields($result);
while ($rows = mysql_fetch_array($result))
       {

   switch($i) {
      case (2):
          if ($rows[$i] == "D")
              $rows[$i] = "Diesel";
          elseif ($rows[$i] != "D")
              $rows[$i] = "Petrol";
          break;
      case (12):
          if ($rows[$i] != "a")
              $rows[$i] = "Manual";
          else
              $rows[$i] = "Automatic";
      break;
//etc.
        } //end switch
} //end while

[phpdeano]

Pig,

REGISTER GLOBALS is different, however the info is not being passed via GET or POST, so that shouldn't be the issue.

I will modify the code as suggested by Drawmack and try again.

I appreciate you taking the time to reply

[phpdeano]

I have re written my switch statement and it still works on the test server but not on the live server.

Getting very stressed now!!!

Can anyone suggest what I might need to change or possibly an alternative method to switch?

All help very welcome

[tsinka]

Hi,

I read your code several times and I'm not sure if you need the switch statement(s) at all. Looks like you want to change some of the values in the row array.

Why not doing something like

if ($rows[2] == "D") {
  $rows[2] = "Diesel";
} else {
  $rows[2] = "Petrol";
}

instead of

      switch($i) 
          { 
          case ($i = 2): 
           if ($rows[$i] == "D") 
           {$rows[$i] = "Diesel";} 
           elseif ($rows[$i] != "D") 
           {$rows[$i] = "Petrol";} 
           break; 
          }  // end 

Same for the other switch statements.

Thomas

[phpdeano]

I knew there was a simple answer to what I needed to do.

Showing my inexperience again

Thank you very much for saving me from suicide tonight!!!!

Kind regards