Question is there something wrong with this syntax when using the MYSQL Update command in PHP , where I change the record by users editing the fields on a web form then those are extracted to update a record in a table. Here's what I have tried I don't get any syntax errors with either of these attempts
$query1 = "UPDATE Qusers SET $field_str WHERE UserName='$username'"; $result2 = mysql_query($query1); Second Example $query1 = "UPDATE Qusers SET BillAmt='$billamt' WHERE UserName='".$username."' AND Qusers.RID ='".$keyid."'"; $result2 = mysql_query($query1); Kory Wheatley --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php