Help doing the simplest thing!!!!!!!!!!!!!

[Philip]

What does the page say

It should say something like:

[quote]INSERT INTO table1....[/quote]

Don't look at the database right now, just the php page and what it outputs.

[Barand]

try odbc_errormsg() instead of odbc_error().

[Bigg]

[quote author=Barand link=topic=122315.msg504861#msg504861 date=1168817531]
try odbc_errormsg() instead of odbc_error().
[/quote] Still nothing.  Get a blank page.

[trq]

Post your current code.

[Bigg]

My current code is [code]<?php
error_reporting(E_ALL);
ini_set("display_errors","1");
if (isset($_POST['Color1']) && isset($_POST['Color2'])) {
  $Color1 = $_POST['Color1'];
  $Color2 = $_POST['Color2'];
  $conn = odbc_connect('Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Program Files\Abyss Web Server\htdocs\p\php imput box\mydb.mdb','','');
  $sql = "INSERT INTO Table1 (Color1, Color2) VALUES ('$Color1', '$Color2')";
echo $sql;
  if (odbc_exec($conn,$sql)) {
    echo "insert success";
  } else {
    echo "insert failed<br />";
    echo odbc_errormsg()."<br />";
    echo $sql;
  }
odbc_close($conn);
}
?>[/code]

[Philip]

It doesn't show anything at all?

Not even something like INSERT INTO... ?

What about you post values, are you sure those are the correct names? Because if one is missing then it won't run the code.

Try changing
odbc_close($conn);
}
to this:
odbc_close($conn);
} else { echo "No colors!"; }

[Bigg]

Says No Colors!

[Bigg]

[quote author=Bigg link=topic=122315.msg504931#msg504931 date=1168827139]
Says No Colors!
[/quote]What the Heck?

[Bigg]

It works!!!!!!!!! Thanks guys for all your help!!!!!!!!

[Philip]

I'm guessing the problem was within the $_POST data?

[Bigg]

[quote author=KingPhilip link=topic=122315.msg504934#msg504934 date=1168827723]
I'm guessing the problem was within the $_POST data?
[/quote]No the columns in my database where not in the right order.