Page 1 of 1

SQL Error

Posted: Wed Sep 14, 2005 12:13 pm
by ianhull
Hi again guys,

another little problem here, well, little to you probably.
Awkward as anything to me.

Here is the code I am using but I get a SQl error

Code: Select all

<?php session_start();
include_once("connect.php");
$idnum = $_POST['recordnum'];
$inpContent = $_POST['inpContent'];
$companyid1 = $_SESSION['companyid'];
$update = "UPDATE `procedures` (`Cpro`) VALUES ('$inpContent') WHERE id='$idnum'";
mysql_query($update) or die(mysql_error());
The error is:

You have an error in your SQL syntax near '(`Cpro`) VALUES ('
myupdatetext</STRON' at line 1

Please, please, please help.

Thanks.

[SOLVED]

Posted: Wed Sep 14, 2005 12:22 pm
by ianhull
Problem Solved