From: George Law
Date: April 12 2006 6:40pm
Subject: RE: Error on T_echo ?? what is this ?
List-Archive: http://lists.mysql.com/mysql/196823
Message-Id: <E0E41B58D485EF469CE5825060B7EB0C9FAB63@corpmail.ION.DOM>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

PHP is picky on what can and cannot be in quotes... I get this all the
time.

Try :=20
$sql =3D "INSERT INTO addvalue (`value1`, `value2`,
`sumfeild`) VALUES ('".$value1."', '".$value2."', '".$sumfield."')";

$result=3DMYSQL_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:admin@stripped]=20
Sent: Wednesday, April 12, 2006 1:37 PM
To: 'Brian E Boothe'; mysql@stripped
Subject: RE: Error on T_echo ?? what is this ?=20

Looks like you're missing a semicolon (;) at the end of this statement:

$result=3DMYSQL_QUERY("INSERT INTO addvalue (`value1`, `value2`,=20
`sumfeild`)"."VALUES ('$value1', '$value2', '$sumfield')"

HTH

Dan
=20
-------------------
http://chrome.me.uk
=20

-----Original Message-----
From: Brian E Boothe [mailto:subrian@stripped]=20
Sent: 13 April 2006 05:13
To: mysql@stripped
Subject: Error on T_echo ?? what is this ?=20

i,m getting the following error on my MySQL Code inserting data into a=20
database, .?

   *Parse error*: parse error, unexpected T_ECHO in=20
c:\inetpub\wwwroot\projects\testsum\adddata.php on line 30
      =20
                                                LINE 30 is       echo=20
"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");
  =20
   //select which database you want to edit
   mysql_select_db("test");

   //convert all the posts to variables:
  $value1 =3D $_POST['value1'];
  $value2 =3D $_POST['value2'];
  $sumfield =3D $_POST['sumfield'];

       //Insert the values into the correct database with the right
fields
   //mysql table =3D news
   //table columns =3D id, title, message, who, date, time
   //post variables =3D $title, $message, '$who, $date, $time
  // $result=3DMYSQL_QUERY("INSERT INTO orders=20
(id,title,message,who,date,time)".
  $result=3DMYSQL_QUERY("INSERT INTO addvalue (`value1`, `value2`,=20
`sumfeild`)".
      "VALUES ('$value1', '$value2', '$sumfield')"
     //INSERT INTO `orders` (`OrderNo`, `CompanyName`, `BillingAddress`,

`City`, `StateOrProvince`, `PostalCode`, `PhoneNumber`, `FaxNumber`,=20
`WebPage`, `ContactFirstName`, `ContactLastName`, `EmailAddress`,=20
`Notes`, `Customer`, `Startdate`, `Completedate`, `Biddate`,=20
`Bidamount`, `ProjectInfo`, `ElecProjCost`, `ElecProjBill`, `ElecRem`,=20
`CtrlProjCost`, `CtrlProjBill`, `CtrlRem`, `OthrProjCost`,=20
`OthrProjBill`, `OthrRem`, `BondAm`, `BondBill`, `BondRem`)
    //confirm
=20
 echo "Query Finished";

?>

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Dmysql_general_discussion@stripped=
k


__________ NOD32 1.1485 (20060412) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com



--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Dglaw@stripped