PHP is picky on what can and cannot be in quotes... I get this all the
time.
Try :
$sql = "INSERT INTO addvalue (`value1`, `value2`,
`sumfeild`) VALUES ('".$value1."', '".$value2."', '".$sumfield."')";
$result=MYSQL_QUERY($sql);
I think part of the error had to do with you missing a ) at the end,
closing the MYSQL_QUERY();
-----Original Message-----
From: Chrome [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 12, 2006 1:37 PM
To: 'Brian E Boothe'; [email protected]
Subject: RE: Error on T_echo ?? what is this ?
Looks like you're missing a semicolon (;) at the end of this statement:
$result=MYSQL_QUERY("INSERT INTO addvalue (`value1`, `value2`,
`sumfeild`)"."VALUES ('$value1', '$value2', '$sumfield')"
HTH
Dan
-------------------
http://chrome.me.uk
-----Original Message-----
From: Brian E Boothe [mailto:[EMAIL PROTECTED]
Sent: 13 April 2006 05:13
To: [email protected]
Subject: Error on T_echo ?? what is this ?
i,m getting the following error on my MySQL Code inserting data into a
database, .?
*Parse error*: parse error, unexpected T_ECHO in
c:\inetpub\wwwroot\projects\testsum\adddata.php on line 30
LINE 30 is echo
"Query Finished";
<<<<----------here is ALL my code ---------->>>>>
<?
//--php/Mysql Code by Brian E Boothe //
//throw data from form into MySQL database routine //
//initilize Adddatta to mysql database, //
//if($_POST['submit']) //If submit is hit
//{
//then connect as user
//change user and password to your mySQL name and password
mysql_connect("localhost","root","goobers");
//select which database you want to edit
mysql_select_db("test");
//convert all the posts to variables:
$value1 = $_POST['value1'];
$value2 = $_POST['value2'];
$sumfield = $_POST['sumfield'];
//Insert the values into the correct database with the right
fields
//mysql table = news
//table columns = id, title, message, who, date, time
//post variables = $title, $message, '$who, $date, $time
// $result=MYSQL_QUERY("INSERT INTO orders
(id,title,message,who,date,time)".
$result=MYSQL_QUERY("INSERT INTO addvalue (`value1`, `value2`,
`sumfeild`)".
"VALUES ('$value1', '$value2', '$sumfield')"
//INSERT INTO `orders` (`OrderNo`, `CompanyName`, `BillingAddress`,
`City`, `StateOrProvince`, `PostalCode`, `PhoneNumber`, `FaxNumber`,
`WebPage`, `ContactFirstName`, `ContactLastName`, `EmailAddress`,
`Notes`, `Customer`, `Startdate`, `Completedate`, `Biddate`,
`Bidamount`, `ProjectInfo`, `ElecProjCost`, `ElecProjBill`, `ElecRem`,
`CtrlProjCost`, `CtrlProjBill`, `CtrlRem`, `OthrProjCost`,
`OthrProjBill`, `OthrRem`, `BondAm`, `BondBill`, `BondRem`)
//confirm
echo "Query Finished";
?>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__________ NOD32 1.1485 (20060412) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
