no non è uno script per la prenotazione

cmq non è li l'errore, ti dico perchè, con questo codice che va ad aggiungere i campi con INSERT funziona benissimo:

Codice PHP:
//fetch credit history
  $creditsql = 'select * from accounting where id = '.$_REQUEST['credit'];
  $creditR = mysql_query($creditsql,$myconn) or die(mysql_error());
  $credit = mysql_fetch_assoc($creditR);
  
  //add property
  $insertSQL = sprintf("INSERT INTO items 
                (`mid`,`countyID`,`testimonial`,`styleID`,`levels`,`sellerTitle`,`sellerName`,`sellerPhone`,`Notes`,
                `sellerEmail`,`expires`,
                `showCities`, cid,  title, price, pdate, sold, description, address, city,
                 `state`, zip, featured, active, bed, bath, subdiv, schoold, `year`, lot_size,
                  sqft, `lat`, `long`,`photoLimit`) 
          VALUES 
              (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, DATE_ADD(NOW(), INTERVAL ".$credit['days']." DAY), '".$citySTR."', %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['mid'],"int"),
                       GetSQLValueString($_POST['countyID'],"int"),
                       GetSQLValueString($_POST['testimonial'], "text"),
                       GetSQLValueString($_POST['styleID'], "int"),
                       GetSQLValueString($_POST['levels'], "text"),
                       GetSQLValueString($_POST['sellerTitle'],"text"),
                       GetSQLValueString($_POST['sellerName'], "text"),
                       GetSQLValueString($_POST['sellerPhone'],"text"),
                       GetSQLValueString($_POST['Notes'],"text"),
                       GetSQLValueString($_POST['sellerEmail'],"text"),
                       GetSQLValueString($_POST['cat'], "int"),
                       GetSQLValueString($_POST['title'], "text"),
                       GetSQLValueString($_POST['price'], "double"),
                       GetSQLValueString(date("Y-m-d"), "date"),
                       GetSQLValueString("No", "text"),
                       GetSQLValueString($_POST['description'], "text"),
                       GetSQLValueString($_POST['address'], "text"),
                       GetSQLValueString($_POST['city'], "int"),
                       GetSQLValueString($_POST['state'], "int"),
                       GetSQLValueString($_POST['zip'], "text"),
                       GetSQLValueString($_POST['featured'], "text"),
                       GetSQLValueString("Yes", "text"),
                       GetSQLValueString($_POST['bed'], "text"),
                       GetSQLValueString($_POST['bath'], "text"),
                       GetSQLValueString($_POST['subdiv'], "text"),
                       GetSQLValueString($_POST['schoold'], "text"),
                       GetSQLValueString($_POST['year'], "int"),
                       GetSQLValueString($_POST['lot_size'], "double"),
                       GetSQLValueString($_POST['sqft'], "double"),
                       GetSQLValueString($address['lat'], "text"),
                       GetSQLValueString($address['long'], "text"),
                       GetSQLValueString($credit['photoLimit'],"int")); 
io devo fare l' UPDATE .. come ho indicato nel primo post. sai come modificarlo?

grazie mille