[SOLVED] PHP and Insert into Access Problem

[rich11]

Hello,

 

I am having problems with this insert statment and I can't see what I am doing wrong.

 

Thx,

 

Rich

 

<?php

 

// This opens the connection

$conn=odbc_connect('eeras','','');

// Checks to see if connection was opened

if ($conn)

{

// Connection was opened

    echo "yepper";

   

     

}

else

{

// Connection Failed

    echo "Nope!";

}

 

// global variables

$answer1 = $_POST["ques1"];

 

$sql = "INSERT INTO rich(Question1) Values('$answer1')";

$result=odbc_exec($conn, $sql);

 

/* check for errors */

if (!odbc_exec($conn, $sql))

{

/* error */

echo "Whoops";

}

[adam291086]

What errors are you getting?

[rich11]

Well that is the problem...

 

I know that the code hits this line...

 

/* error */

echo "Whoops";

 

Because "Whoops" is displayed in the browser.

 

But I don't get errors.  Say like in ASP or Coldfusion displayed on the screen.  I have tried using IE, Netscape and Firefox.  I wish PHP would kick errors, but is doesn't or do I not ahve the browsers set up right?

 

Rich

 

 

[rich11]

I have changed my insert statement to this....

 

$query = odbc_exec($conn, "INSERT INTO rich(Question1) Values('$answer')") or die (odbc_errormsg());

 

 

This is the error msg I get...

 

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

[adam291086]

that means you need to add write permissions to the file you are attempting to write to or to the folder that contains the file(s) you are attempting to write to.

 

[rich11]

yes.. I just google that error that is what I read.. thank you for your help.

 

It was much appreciated.

 

Rich