Table update function

[Mythotical]

Ok I have this function:

PHP Code:

function saveSettings()
{
  global $db;
  
    $xsdl_active = $_REQUEST['xsdl_active'];
      $server_path = $_REQUEST['server_path'];
      $xsdl_closed = $_REQUEST['xsdl_closed'];
      $nav_active = $_REQUEST['nav_active'];
    $xsdl_file_name = $_REQUEST['xsdl_file_name'];
    
    $db->query_write("
        UPDATE `" . TABLE_PREFIX . "xsdl_settings`
        SET set_value= array('$xsdl_closed', '$server_path', '$xsdl_active', '$nav_active', '$xsdl_file_name') WHERE varname = array('xsdl_closed', 'server_path', 'xsdl_active', 'nav_active', 'xsdl_file_name')
    ");
                      
  return $db->insert_id();
} 


I'm not sure how I should use array so it will run as I show above. I tried that but it failed, gonna keep trying while I wait for a reply here but could anyone give me the proper way to handle array's like above?

Thanks
Steve

[Opserty]

Is this using vBulletin back-end? If so make sure you read this: Using the vBulletin Input Cleaner, before you go any further in reading my post.

To store an array in a database row you need to serialize it in a string. See the PHP manual for information on serialize() and unserialize().

An example:

PHP Code:

$arrayone = array('bla', 'bla', 'bla');
$arrayone = serialize($arrayone);
// $db->query_write("UPDATE....SET somecol = ". $arrayone ."...

//=================================

// $db->query_read("SELECT * FROM....
// $row = $db->fetch_array...
$data = unserialize($data['somecol']); 


[Adrian Schneider]

What you want is a CASE statement.

[sql]UPDATE table
SET set_value =
CASE
WHEN set_varname = 'X'
THEN $value_for_x

WHEN set_varname = 'Y'
THEN $value_for_y
END
WHERE set_varname IN ('X', 'Y')[/sql]

[Opserty]

Oh whoops I didn't see all of your query Steve M. My apologies. :erm: