insert into problem

prøv denne

$sqlQuery = "INSERT INTO prodList (name, desc, price, code) VALUES ('$prodName', '$prodDesc', '$prodPrice', '$prodCode')or die("Error opening database .... use the browsers BACK button")";

Ja... Prøv:
$sqlQuery = ("insert into prodList (name, desc, price, code) VALUES ('".$prodName."', '".$prodDesc."', '".$prodPrice."', '".$prodCode."')")  or die("Error opening database .... use the browsers BACK button");

Bare se bort fra min... Syvon's version er rigtig... (tror jeg) :)

ja, det hjalå en del
nu er de blot lidt ballade her

Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl i INSERT INTO-sætningen., SQL state 37000 in SQLExecDirect in C:\Documents and Settings\Dennis\Skrivebord\localhost\prodadd1.php on line 58

$dbResult = odbc_exec($dbConn, $sqlQuery)or die("Product record update failed");

nej faktisk ikke, din kom et skridt videre

lavede en mindre fejl

$sqlQuery = "INSERT INTO prodList (name, desc, price, code) VALUES ('$prodName', '$prodDesc', '$prodPrice', '$prodCode')" or die("Error opening database .... use the browsers BACK button");

Det hjalp også, men nu er det denne her der fejler

$dbResult = odbc_exec($dbConn,$sqlQuery) or die("Product add failed");

come guys

Det er det sidste jeg mangler

<br>
<?php
 
    // connect to the database
    $dbConn = odbc_connect("flamingo","","")
      or die("Error opening database .... use the browsers BACK button");

    // store the products new details from the POST
  $code =  $_POST["prodcode"];
  $name =  $_POST["prodname"];
  $desc =  $_POST["proddesc"];
  $price = $_POST["prodprice"];

    // just do a final check to make sure the product exists
    $sqlQuery = "select * from prodList where prodCode='" . $code . "'";
  $dbResult = odbc_exec($dbConn,$sqlQuery) or die("Error, Product Listing failed .... use the browsers BACK button");
    $res = odbc_fetch_row($dbResult);
    if ($res == TRUE) {
      echo("<p> The product with code " . $code . "  exist in the products table");
      echo("<p><a href='prodadd.html'>Go back</a>");
      die("<br><br>");
    }

  //$sqlQuery ="INSERT INTO prodList(name,desc,price,code) VALUES(prodName,prodDesc,prodPrice,prodCode) ";
//$sqlQuery2 = ("insert into prodList (name, desc, price, code) VALUES ('".$name."', '".$desc."', '".$price."', '".$code."')")  or die("Error opening database .... use the browsers BACK button");

$sqlQuery = "INSERT INTO prodList (name, desc, price, code) VALUES ('$name', '$desc', '$price', '$code')" or die("Error opening database .... use the browsers BACK button");
// $dbConn = odbc_do( $dbConn, $sqlQuery ) or die("Product add failed");

$dbResult = odbc_exec($dbConn,$sqlQuery) or die("Product add failed");

 
    odbc_close($dbConn);
?>

sådan ser hele koden ud

der bliver jeg så nød til at melde pas :)

$sqlQuery = "insert into prodList (prodCode, prodName, prodDesc, prodPrice) values ('$code', '$name' ,'$desc', '$price')";

sådan skulle den se ud