olivebranchms/obms_r3/admin/item_update.php3

<?php // send page properties to the db

require("../db.php3");

$connection = connect($host,$dbname);
if($connection) {
  $query  = "update item set\n";
  $query .= "ord='$ord', type='$type', ";
  $query .= "class='$class', clear='$clear', ";
  $query .= "alt='" . trim(addslashes($alt)) . "', ";
  $query .= "url='$url',\n";
  $query .= "dat='" . trim(addslashes($dat)) . "'\n where id='$id'\n";
  $result = query($connection, $query);
  $rows   = mysql_affected_rows($connection);
//  print("<!--\n$query\n-->\n");
  if($rows) {
    $q2 = "update page set changed=NULL where id=$pid";
    $update = query($connection, $q2);
    header("Location: http://$domain/admin/page_edit.php3?pid=$pid");
//    include("intro.php3");
//    print("<div class=center>\n");
//    print("<b>Database Successfully updated...<hr width=50%></b><br><br>\n");
//    print("<a href=\"index.php3\"><img src=\"btn.php3?label=Page+List ");
//    print("alt=\"Page List\" border=0></a><br><br>\n");
//    print("<a href=\"page_edit.php3?pid=$pid\"><img src=\"btn.php3?label=");
//    print("Item+List\" alt=\"Item List\" border=0></a><br>\n");
  } else {
    $error = mysql_error($connection);
    print("database error: $error\n");
  }
}