[php_mysql] update form Issues, > heellpp

Brian E Boothe Sun, 05 Nov 2006 18:04:33 -0800

My following Extensive code Grab's Form Update Values from a link , so I can
change Values to update a MySQL database, but im getting an error 
     Can someone Please help me out getting this form to update the values


Im getting the error 

Fatal error: Call to undefined function VALUES() in
c:\Inetpub\wwwroot\Forms\Workorders\updateform.php on line 10
  
   Line 10 is >> 
 
VALUES('$id','$ordernumber','$billingaddress','City','State','Zip','PhoneNum
ber','FaxNumber','WebPage','EmailAddress','Notes','Customer','Startdate','Co
mpletedate','Biddate','Bidamount','ElecProjCost','ElecProjBill','ElecRem','C
trlProjCost','CtrlProjBill','CtrlProjrem','OthrProjCost','OthrProjBill','Oth
rProjrem','AllRemainSum','BondAm','BondBill','BondRem') or

     Look at the bottom of this post  for Complete PHP Page updateform.php
)) */



<? 
/ ( "detailupdate.php ")  */ ?> 

<?php require_once('Connections/idata.php'); ?><?php
$maxRows_DetailRS1 = 10;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
  $pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;

mysql_select_db($database_idata, $idata);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT * FROM workorders WHERE companyname =
'$recordID'";
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1,
$startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $idata) or
die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);

if (isset($_GET['totalRows_DetailRS1'])) {
  $totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
  $all_DetailRS1 = mysql_query($query_DetailRS1);
  $totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd";>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
        background-image: url(RSSCreen.gif);
}
.inp {height:17px; 
font-size:7pt; 
font-family:comic sans ms, verdana, sans serif; 
background-color:#ffffcc; 
}
.style1 {color: #FFFFFF}
-->
</style></head>

<body>
                
<div align="left"></div>
<form name="form1" method="post" action="updateform.php">
  <table width="559" border="0" cellpadding="0" cellspacing="0">
    <tr valign="baseline"> 
      <td align="right" nowrap bgcolor="#003366"><span
class="style1">id</span></td>
      <td colspan="3" bgcolor="#CCCCCC"><input type="text" name="id2"
value="<?php echo $row_DetailRS1['id']; ?>" size="15"></td>
      <td bgcolor="#003366"><span class="style1">Company</span></td>
      <td bgcolor="#CCCCCC"><?php echo $row_DetailRS1['companyname'];
?></td>
      <td bgcolor="#003366">&nbsp;</td>
      <td bgcolor="#CCCCCC">&nbsp;</td>
    </tr>
    <tr valign="baseline"> 
      <td width="86" align="right" nowrap bgcolor="#003366"><font
color="#FFFFFF" size="2">Ordernumber:</font></td>
      <td colspan="3" bgcolor="#CCCCCC"><?php echo
$row_DetailRS1['ordernumber']; ?> 
      </td>
      <td bgcolor="#003366"> <div align="right"><font color="#FFFFFF"
size="2">Companyname</font></div></td>
      <td bgcolor="#CCCCCC"><?php echo $row_DetailRS1['companyname']; ?>
</td>
      <td width="76" bgcolor="#003366"><font color="#FFFFFF"
size="2">Billingaddress</font></td>
      <td width="93" bgcolor="#CCCCCC"> <div align="left"><font
color="#000000"> 
          <input type="text" name="billingaddress22" value="<?php echo
$row_DetailRS1['billingaddress']; ?>" size="15">
          </font></div></td>
    </tr>
    <tr valign="baseline"> 
      <td align="right" nowrap bgcolor="#003366"><font color="#FFFFFF"
size="2">City::</font></td>
      <td colspan="3" bgcolor="#CCCCCC"><input type="text" name="City22"
value="<?php echo $row_DetailRS1['City']; ?>" size="15"> 
      </td>
      <td bgcolor="#003366"> <div align="right"><font color="#FFFFFF"
size="2">State:</font></div></td>
      <td bgcolor="#CCCCCC"><input type="text" name="State22" value="<?php
echo $row_DetailRS1['State']; ?>" size="5"> 
      </td>
      <td bgcolor="#003366"><div align="right"><font color="#FFFFFF"
size="2">Zip:</font></div></td>
      <td bgcolor="#CCCCCC"> <div align="left"><font color="#000000"> 
          <input type="text" name="Zip22" value="<?php echo
$row_DetailRS1['Zip']; ?>" size="15">
          </font></div></td>
    </tr>
    <tr valign="baseline"> 
      <td align="right" nowrap bgcolor="#003366"><font color="#FFFFFF"
size="2">PhoneNumber::</font></td>
      <td colspan="3" bgcolor="#CCCCCC"><input type="text"
name="PhoneNumber22" value="<?php echo $row_DetailRS1['PhoneNumber']; ?>"
size="15"> 
      </td>
      <td bgcolor="#003366"> <div align="right"><font color="#FFFFFF"
size="2">FaxNumber:</font></div></td>
      <td bgcolor="#CCCCCC"><input type="text" name="FaxNumber22"
value="<?php echo $row_DetailRS1['FaxNumber']; ?>" size="15"> 
      </td>
      <td bgcolor="#003366"><div align="right"><font color="#FFFFFF"
size="2">WebPage:</font></div></td>
      <td bgcolor="#CCCCCC"> <div align="left"><font color="#000000"> 
          <input type="text" name="WebPage22" value="<?php echo
$row_DetailRS1['WebPage']; ?>" size="15">
          </font></div></td>
    </tr>
    <tr valign="baseline"> 
      <td align="right" nowrap bgcolor="#003366"><font color="#FFFFFF"
size="2">EmailAddress:</font></td>
      <td colspan="3" bgcolor="#CCCCCC"><input type="text"
name="EmailAddress22" value="<?php echo $row_DetailRS1['EmailAddress']; ?>"
size="15"> 
      </td>
      <td bgcolor="#003366"> <div align="right"><font color="#FFFFFF"
size="2">Customer:</font></div></td>
      <td bgcolor="#CCCCCC"><input type="text" name="Customer22"
value="<?php echo $row_DetailRS1['Customer']; ?>" size="15"> 
      </td>
      <td bgcolor="#003366"><div align="right"><font
color="#FFFFFF">&nbsp;</font></div></td>
      <td bgcolor="#CCCCCC"> <div align="left"><font color="#000000"
size="2">&nbsp;</font></div></td>
    </tr>
    <tr valign="baseline"> 
      <td rowspan="3" align="right" nowrap bgcolor="#003366"><font
color="#FFFFFF" size="2">Notes:</font></td>
      <td colspan="3" rowspan="3"><textarea name="textarea" cols="16"><?php
echo $row_DetailRS1['Notes']; ?></textarea></td>
      <td bgcolor="#003366"> <div align="right"><font color="#FFFFFF"
size="2">Startdate:</font></div></td>
      <td bgcolor="#CCCCCC"><input type="text" name="Startdate22"
value="<?php echo $row_DetailRS1['Startdate']; ?>" size="15"> 
      </td>
      <td bgcolor="#003366"><div align="right"><font color="#FFFFFF"
size="2">Completedate</font></div></td>
      <td bgcolor="#CCCCCC"> <div align="left"><font color="#000000"
size="2"> 
          <input type="text" name="Completedate22" value="<?php echo
$row_DetailRS1['Completedate']; ?>" size="15">
          </font></div></td>
    </tr>
    <tr valign="baseline"> 
      <td bgcolor="#003366"> <div align="right"><font color="#FFFFFF"
size="2">Biddate:</font></div></td>
      <td bgcolor="#CCCCCC"><input type="text" name="Biddate22" value="<?php
echo $row_DetailRS1['Biddate']; ?>" size="15"> 
      </td>
      <td bgcolor="#003366"><div align="right"><font color="#FFFFFF"
size="2">Bidamount</font></div></td>
      <td bgcolor="#CCCCCC"> <div align="left"><font color="#000000"
size="2"> 
          <input type="text" name="Bidamount22" value="<?php echo
$row_DetailRS1['Bidamount']; ?>" size="15">
          </font></div></td>
    </tr>
    <tr valign="baseline"> 
      <td colspan="4"><div align="right"><font size="2"></font></div></td>
    </tr>
    <tr valign="baseline"> 
      <td align="right" valign="top" nowrap bgcolor="#FFFFFF"><font
color="#000000" size="2">ElecProjCost:</font></td>
      <td width="42" bgcolor="#FFFFFF"> <input type="text"
name="ElecProjCost22" value="<?php echo $row_DetailRS1['ElecProjCost']; ?>"
size="6"> 
      </td>
      <td width="68" bgcolor="#FFFFFF"><font color="#000000"
size="2">ElecProjBill:</font></td>
      <td width="38"><input type="text" name="ElecProjBill22" value="<?php
echo $row_DetailRS1['ElecProjBill']; ?>" size="6"></td>
      <td width="81" bgcolor="#FFFFFF"> <div align="right"><font
color="#000000" size="2">ElecRem</font></div></td>
      <td width="68" bgcolor="#FFFFFF"> <font color="#000000"> 
        <input type="text" name="ElecRem22" value="<?php echo
$row_DetailRS1['ElecRem']; ?>" size="6">
        </font></td>
      <td colspan="2" bgcolor="#FFFFFF"><font
color="#000000">&nbsp;</font></td>
    </tr>
    <tr valign="baseline"> 
      <td align="right" nowrap bgcolor="#FFFFFF"><font color="#000000"
size="2">CtrlProjCost:</font></td>
      <td bgcolor="#FFFFFF"><input type="text" name="CtrlProjCost2"
value="<?php echo $row_DetailRS1['CtrlProjCost']; ?>" size="6"> 
      </td>
      <td bgcolor="#FFFFFF"><font color="#000000"
size="2">CtrlProjBill:</font></td>
      <td><input type="text" name="CtrlProjBill2" value="<?php echo
$row_DetailRS1['CtrlProjBill']; ?>" size="6"></td>
      <td bgcolor="#FFFFFF"> <div align="right"><font color="#000000"
size="2">CtrlProjrem:</font></div></td>
      <td bgcolor="#FFFFFF"> <font color="#000000"> 
        <input type="text" name="CtrlProjrem2" value="<?php echo
$row_DetailRS1['CtrlProjrem']; ?>" size="6">
        </font></td>
      <td colspan="2" bgcolor="#FFFFFF"><font
color="#000000">&nbsp;</font></td>
    </tr>
    <tr valign="baseline"> 
      <td align="right" nowrap bgcolor="#FFFFFF"><font color="#000000"
size="2">OthrProjCost:</font></td>
      <td bgcolor="#FFFFFF"><input type="text" name="OthrProjCost2"
value="<?php echo $row_DetailRS1['OthrProjCost']; ?>" size="6"> 
      </td>
      <td bgcolor="#FFFFFF"><font color="#000000"
size="2">OthrProjBill:</font></td>
      <td><input type="text" name="OthrProjBill2" value="<?php echo
$row_DetailRS1['OthrProjBill']; ?>" size="6"></td>
      <td bgcolor="#FFFFFF"> <div align="right"><font color="#000000"
size="2">OthrProjrem:</font></div></td>
      <td bgcolor="#FFFFFF"> <font color="#000000"> 
        <input type="text" name="OthrProjrem2" value="<?php echo
$row_DetailRS1['OthrProjrem']; ?>" size="6">
        </font></td>
      <td colspan="2" bgcolor="#FFFFFF"><font
color="#000000">&nbsp;</font></td>
    </tr>
    <tr valign="baseline"> 
      <td align="right" nowrap bgcolor="#FFFFFF"><font color="#000000"
size="2">BondAm:</font></td>
      <td bgcolor="#FFFFFF"><input type="text" name="BondAm2" value="<?php
echo $row_DetailRS1['BondAm']; ?>" size="6"> 
      </td>
      <td bgcolor="#FFFFFF"><font color="#000000"
size="2">BondBill:</font></td>
      <td><input type="text" name="BondBill2" value="<?php echo
$row_DetailRS1['BondBill']; ?>" size="6"></td>
      <td bgcolor="#FFFFFF"> <div align="right"><font color="#000000"
size="2">BondRem:</font></div></td>
      <td bgcolor="#FFFFFF"> <font color="#000000">
        <input type="text" name="BondRem2" value="<?php echo
$row_DetailRS1['BondRem']; ?>" size="6">
        </font></td>
      <td colspan="2" bgcolor="#FFFFFF"><font color="#000000">&nbsp;
</font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right">&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td bgcolor="#FFFFFF"><font size="2">AllRemainSum:</font></td>
      <td bgcolor="#FFFFFF"> <font color="#000000"> 
        <input type="text" name="AllRemainSum2" value="<?php echo
$row_DetailRS1['AllRemainSum']; ?>" size="15">
        </font></td>
      <td colspan="2" bgcolor="#FFFFFF"><font
color="#000000">&nbsp;</font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right">&nbsp;</td>
      <td colspan="7"><input name="submit22" type="submit" value="Update
record"> 
      </td>
    </tr>
  </table>
</form>
</body>
</html><?php
mysql_free_result($DetailRS1);
?>


---------------------------------------------------------------------------
<?  // ((  updateform.php )) */
                      
 $link = mysql_connect('localhost','root', 'goobers') 
        or die("Could not connect"); 
    mysql_select_db('idata') 
        or die("Could not select database"); 

    $insert=mysql_query("UPDATE Workorders (id=%s, ordernumber=%s,
billingaddress=%s, City=%s, `State`=%s, Zip=%s, PhoneNumber=%s,
FaxNumber=%s, WebPage=%s, EmailAddress=%s, Notes=%s, Customer=%s,
Startdate=%s, Completedate=%s, Biddate=%s, Bidamount=%s, ElecProjCost=%s,
ElecProjBill=%s, ElecRem=%s, CtrlProjCost=%s, CtrlProjBill=%s,
CtrlProjrem=%s, OthrProjCost=%s, OthrProjBill=%s, OthrProjrem=%s,
AllRemainSum=%s, BondAm=%s, BondBill=%s, BondRem=%s WHERE companyname=%s");
 
VALUES('$id','$ordernumber','$billingaddress','City','State','Zip','PhoneNum
ber','FaxNumber','WebPage','EmailAddress','Notes','Customer','Startdate','Co
mpletedate','Biddate','Bidamount','ElecProjCost','ElecProjBill','ElecRem','C
trlProjCost','CtrlProjBill','CtrlProjrem','OthrProjCost','OthrProjBill','Oth
rProjrem','AllRemainSum','BondAm','BondBill','BondRem') or 
        die('couldn\'t Insert record into database :'.mysql_error()); 
             echo'The Record was inserted succesfully into Database'; 
       ?>




-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.13.28/518 - Release Date: 11/4/2006
 



The php_mysql group is dedicated to learn more about the PHP/MySQL web database 
possibilities through group learning.  
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php_mysql/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/php_mysql/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[EMAIL PROTECTED] 
    mailto:[EMAIL PROTECTED]

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

[php_mysql] update form Issues, > heellpp

Reply via email to