how to make this easyer!!!

[TheTiger]

I want to make this easyer, or in one statement not one everyone.

the code I have is this:

 <?php
/**
 * ====================
 * ks81 v1.0
 * ====================
 *
 * File      : ./admin/ommegadmin.php
 * Copyright : 2004 (c) Kenneth Sørensen
 * Info      : Header Settings.
 *
 ***************************************/
error_reporting(E_ALL);
require_once '../configks81.php';
$dbcnx = @mysql_connect($config['MySQL_host'], $config['MySQL_username'], $config['MySQL_pasword']);
if (!$dbcnx)
{
  echo '<p>For tiden ikkje mulig å få kontakt med serveren.</p>';
}
/**
 * Select the database
 */
if (! @mysql_select_db($config['MySQL_database']) ) 
{
 echo '<p>For tiden umulig å finne databasen<b>' . $config['MySQL_database'] . '</b></p>';
exit;
}
if(isset($_POST['submit']))
{
 $navn = $_POST['navn'];
 $bosted = $_POST['bosted'];
 $by = $_POST['by'];
 $fylke = $_POST['fylke'];
 $land = $_POST['land'];
 $morsmål = $_POST['morsmål'];
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$navn.'" WHERE ommeg_id = "navn"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>38 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$bosted.'" WHERE ommeg_id = "bosted"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>43 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$by.'" WHERE ommeg_id = "by"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>52 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$fylke.'" WHERE ommeg_id = "fylke"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>457 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$land.'" WHERE ommeg_id = "land"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>62 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$morsmål.'" WHERE ommeg_id = "morsmål"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>67 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
  else
  {
  echo'lagret<hr />';
  }
 
}
echo '
<table>
 <tr><td>
  <form enctype="multipart/form-data" action="ommegadmin.php" method="post">
 </td></tr>';
$query = mysql_query('SELECT * FROM ommeg');
while($array = mysql_fetch_array($query))
{
 echo '<tr><td>
  '.$array['ommeg_tittel'].':
 </td>
 <td>
  <textarea name="'.$array['ommeg_id'].'" cols="" rows="">'.$array['ommeg_tekst'].'</textarea>
 </td></tr>';
}
 
echo ' <tr><td>
  <input type="submit" name="submit" value="Lagre">
 </td></tr>
 <tr><td>
  </form>
  <br>
  <br>
 </td></tr>
</table>';
 
 /**
 *
 *  Last updated : 21.04-2004
 * Info     : 
 *
 ***************************************/
?>

Can anyone help me making this part easyer??:

  if(isset($_POST['submit']))
{
 $navn = $_POST['navn'];
 $bosted = $_POST['bosted'];
 $by = $_POST['by'];
 $fylke = $_POST['fylke'];
 $land = $_POST['land'];
 $morsmål = $_POST['morsmål'];
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$navn.'" WHERE ommeg_id = "navn"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>38 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$bosted.'" WHERE ommeg_id = "bosted"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>43 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$by.'" WHERE ommeg_id = "by"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>52 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$fylke.'" WHERE ommeg_id = "fylke"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>457 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$land.'" WHERE ommeg_id = "land"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>62 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
 $sql = 'UPDATE ommeg SET ommeg_tekst = "'.$morsmål.'" WHERE ommeg_id = "morsmål"';
  if( !$query = mysql_query($sql) )
  {
  echo '<p>67 Could not change do to an problem in the MySQL: '.mysql_error().'</p><hr />';
  }
  else
  {
  echo'lagret<hr />';
  }
 
} 

[r937]

i don't know about the php but
you cannot make the sql any easier

if you want to update 6 different rows
then you have to use 6 different UPDATE statements

[TheTiger]

As i thought....

Thank you!!