New problem

supercites_net

Please don't get mad at me. I have defenses:
1)New file
2)Searched posts
3)No manual, I'm using a remote host.
I get this error:
Parse error: syntax error, unexpected T_VARIABLE on line 27
with this code:

<html>
<head>
<title>Merced Trailer Sales Inventory Action</title>

</head><body>
<?php
$con = mysql_pconnect("localhost",$_COOKIE["username"],$_COOKIE["password"], MYSQL_CLIENT_SSL);
if (!$con)
  {
  die("Could not connect to server because:"  . mysql_error());
  }
mysql_select_db("eagleonehiphp_sql", $con);
IF ($_GET["q"]=="add"){
echo "<form action='inventoryprocess.php' method='POST'>Adding Brand:<select name='brand' size=11><Option value='Featherlite'>Featherlite
<Option value='Big Tex'>Big Tex
<option value='Wells Cargo'>Wells Cargo
<option value='Trailmax'>Trailmax
<option value='Echo'>Echo
<option value='Dargo'>Dargo
<option value='Big Lug'>Big Lug
</select>
Stock #<Input type='text' name='stock' size=8 maxlength=8 /> Model #<Input type='text' name='model' size=8 maxlength=8 /> VIN #<Input type='text' name='VIN' size=8 maxlength=8 /> Description<textarea name='description' rows=2 cols=20 maxlength=255></textarea>
Retail $<Input type='text' name='retail' size=8 maxlength=8 /> Cost $<Input type='text' name='cost' size=8 maxlength=8 /><Input type='hidden' name='action' value='add2' /><Input type='submit' Name='submit' value='Submit' /></form>";}
IF ($_POST["action"]=="add2"){
$result = mysql_query("INSERT INTO inventory (Brand, Stock, Model, VIN, Description, Retail, Cost) 
VALUES ("$_POST[Brand] .", "$_POST[stock]","$_POST[model]", "$_POST[VIN]", "$_POST[description]", "$_POST[retail]", "$_POST[cost]")");}
echo "Stock #" mysql_result($result,0,table.Stock) " sucessfully added to Brand: " mysql_result($result,0,table.Brand)
IF ($_GET["q"]=="edit"){
echo "<Form action='inventoryprocess.php' method='POST'>Edit Stock #<Input type='text' name='stocktoedit' value='' size=8 maxlength=8 /><Input type='hidden' name='action' value='edit2' /><Input type='submit' name='submit' value='Submit' /></form>";}
IF ($_POST["action"]=="edit2"){
$result = mysql_query("SELECT * FROM inventory
WHERE Stock="$_POST['stocktoedit'] ."); while($row = mysql_fetch_array($result)){
echo "<FORM action='inventoryprocess.php' method='POST'> Editing: Brand: <Input type='text' name='brand' value='". $row['Brand'] ."' size=8 maxlength=8 /> Stock #<Input type='text' name='editstock' value='"$_POST('stocktoedit')"' /> 
Model #<Input type='text' name='model' value='". $row['Model'] ."' size=8 maxlength=8 /> VIN<Input type='text' name='VIN' value='". $row['VIN'] ."' size=8 maxlength=8 />
<Textarea name='description' rows=2 cols=20 maxlength=255>". $row['Description'] ."</textarea> 
Retail $<Input type='text' name='retail' value='". $row['Retail'] ."' size=8 maxlength=8 /> Cost $<Input type='text' name='cost' value='". $row['Cost'] ." size=8 maxlength=8 /><Input type='hidden' name='action' value='edit3' size=8 maxlength=8 /><Input type='submit' name='submit' value='Submit' /></form>";}}
IF ($_POST["action"]=="edit3"){
$result=mysql_query("UPDATE Inventory SET Brand = '"$_POST['brand']"' SET Model = "$_POST['model']" SET VIN = '"$_POST['VIN']"' SET Description = '"$_POST['description']"' SET Retail = '"$_POST['retail']"' SET Cost = '"$_POST['cost']"' 
WHERE Stock='"$_POST['editstock']");
echo "Stock # ". $_POST['editstock'] ." successfully updated";}
IF ($_GET["q"]=="delete"){
echo "<Form action='inventoryprocess.php' method='POST'>Delete Stock #<Input type='text' name='stocktodelete' value='' size=8 maxlength=8 /><Input type='hidden' name='action' value='delete2' /> Are you sure?<Input type='submit' name='yes' value='Yes' /><button name='no' onClick='window.close'>No</button></form>";}
IF $_POST["action"]=="delete2"){
mysql_query("DELETE FROM Inventory WHERE Stock='"$_POST['stocktodelete']"'");
echo "Stock # ". $_POST['stocktodelete'] .";}
IF ($_GET["q"]=="show"){
echo "<FORM action="inventoryprocess.php" method="POST">
Show: <Input type='radio' name='showmethod' value='all'>All <Input type='radio' name='showmethod' value='brand'>Brand: <select name='brand' size=11><Option value='Featherlite'>Featherlite
<Option value='Big Tex'>Big Tex
<option value='Wells Cargo'>Wells Cargo
<option value='Trailmax'>Trailmax
<option value='Echo'>Echo
<option value='Dargo'>Dargo
<option value='Big Lug'>Big Lug
</select> <Input type='radio' name='showmethod' value='stock'>Stock #<Input type='text' name='stocktoshow' value='' size=8 maxlength=8 /><Input type='hidden' name='action' value='show2' /><Input type='submit' name='submit' value='Submit' /></form>";}
IF ($_POST["action"]=="show2"){
IF ($_POST["showmethod"]=="all"){
result = mysql_query("SELECT * FROM Inventory ORDER BY Brand, Stock");
while($row = mysql_fetch_array($result))
  {
  echo "<table>"
  echo "<tr> <td>Brand</td><td>Stock #</td><td>Model #</td><td>VIN</td><td>Description</td><td>Retail $</td><td>Cost $</td></tr>"
  echo "<tr><td>". $row['Brand'] ."</td>";
  echo "<td>". $row['Stock'] ."</td>";
  echo "<td>". $row['Model'] ."</td>";
  echo "<td>". $row['VIN'] ."</td>";
  echo "<td>". $row['Description'] ."</td>";
  echo "<td>". $row['Retail'] ."</td>";
  echo "<td>". $row['Cost'] ."</td></tr></table";
  }}
IF ($_POST["showmethod"]=="brand"){
$result = mysql_query("SELECT * FROM Inventory WHERE Brand = '"$_POST['brand']"' ORDER BY Stock");
while($row = mysql_fetch_array($result))
  {
  echo "<table>"
  echo "<tr> <td>Brand</td><td>Stock #</td><td>Model #</td><td>VIN</td><td>Description</td><td>Retail $</td><td>Cost $</td></tr>"
  echo "<tr><td>". $row['Brand'] ."</td>";
  echo "<td>". $row['Stock'] ."</td>";
  echo "<td>". $row['Model'] ."</td>";
  echo "<td>". $row['VIN'] ."</td>";
  echo "<td>". $row['Description'] ."</td>";
  echo "<td>". $row['Retail'] ."</td>";
  echo "<td>". $row['Cost'] ."</td></tr></table";
  }}
IF ($_POST["showmethod"]=="stock"){
$result = mysql_query("SELECT * FROM Inventory WHERE Stock = '"$_POST['stocktoshow']"'");

while($row = mysql_fetch_array($result))
  {
  echo "<table>"
  echo "<tr> <td>Brand</td><td>Stock #</td><td>Model #</td><td>VIN</td><td>Description</td><td>Retail $</td><td>Cost $</td></tr>"
  echo "<tr><td>". $row['Brand'] ."</td>";
  echo "<td>". $row['Stock'] ."</td>";
  echo "<td>". $row['Model'] ."</td>";
  echo "<td>". $row['VIN'] ."</td>";
  echo "<td>". $row['Description'] ."</td>";
  echo "<td>". $row['Retail'] ."</td>";
  echo "<td>". $row['Cost'] ."</td></tr></table";
  }}}
?>
<br/><A onClick="window.close">close Window</a>
</body>
</html>

NogDog

Looks like your quoting gets a bit funky here within the VALUES expression:

IF ($_POST["action"]=="add2"){
   $result = mysql_query("INSERT INTO inventory (Brand, Stock, Model, VIN, Description, Retail, Cost)
   VALUES ("$_POST[Brand] .", "$_POST[stock]","$_POST[model]", "$_POST[VIN]", "$_POST[description]", "$_POST[retail]", "$_POST[cost]")");
}

What you probably want is something like:

IF ($_POST["action"]=="add2"){
   $result = mysql_query("INSERT INTO inventory (Brand, Stock, Model, VIN, Description, Retail, Cost)
   VALUES ('{$_POST['Brand']}', '{$_POST['stock']}', '{$_POST['model']}', '{$_POST['VIN']}', '{$_POST['description']}', '{$_POST['retail']}', '{$_POST['cost']}')");
}

Weedpacket

The syntax highlighting also shows up a problem with

echo "Stock # ". $_POST['stocktodelete'] .";}

and

WHERE Stock="$_POST['stocktoedit'] ."); while($row = mysql_fetch_array($result)){