there is no such values function in php that's the reason of the error
if the values field should with the UPDATE statement then you are expecting
mysql error.
syntax for UPDATE is:
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]
i usually do:
UPDATE table SET col1="val1", col3="val3", col2="val2" WHERE id="1";
syntax for INSERT is:
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES ({expr | DEFAULT},...),(...),...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]
usually:
INSERT INTO table('col', 'value') VALUES('col1val', 'value1val');
hope to help
~kray | 418871
learn the rules so you know how to break them properly -unknown
----- Original Message ----
From: Brian E Boothe <[EMAIL PROTECTED]>
To: [email protected]
Sent: Monday, 6 November, 2006 9:55:42 AM
Subject: [php_mysql] update form Issues, > heellpp
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"> </td>
<td bgcolor="#CCCCCC"> </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"> </font></div></td>
<td bgcolor="#CCCCCC"> <div align="left"><font color="#000000"
size="2"> </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"> </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"> </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"> </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">
</font></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td> </td>
<td> </td>
<td> </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"> </font></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </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
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
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/
