Brian E Boothe wrote:
> 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";
Wrong list.
The echo is unexpected because you're missing a semicolon at the end of
the previous line. Also should 'sumfeild' be 'sumfield'?
PB
>
> <<<<----------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";
>
> ?>
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.1/309 - Release Date: 4/11/2006
