Store data in Access Database

[[deleted]]

Hi, I want to store data from a formular in an access database. The connection to the Database thru ODBC works, I have succesfuly gotton my data out of it.
My problem basically is: I haven't found an example script, to move along, can anybody help me on this? Or drop me a line on how this works?
all I need is odbc_prepare(.....

...)
I check for success in Access

In MySQL I figured it out, but I don't have and can't install MySQL.
Thx folks

[tjumlani]

Assuming that you have the following variables in your form:

global $id, $name;

$o = odbc_connect("MyDB","","");

// to add a new record
sql = "Insert into members(id,name)values('$id','$name')";

if (!odbc_exec($sql,$o)) {
echo "Error in insertion...";
}
else
echo "Record successfully inserted...";

// to update an old record

$sql = "Update members set name='$name' where id='$id'";
if (!odbc_exec($sql,$o)) {
echo "Update unsuccessfull...";
}
else
echo "Update successfull....";

// to delete a record
$sql = "Delete from members where id='$id'";
if (!odbc_exec($sql,$o) {
echo "Deletion unsuccessfull....";
}
else
echo "Deletion successfull....";

// to view a record or records
$sql = "Select * from members where id='$id'";
$rs = odbc_exec($sql,$o);

if ($rs) {
echo "Error in query...."
}
else
odbc_result_all($rs);

[jabro]

thx, this helps me a lot
Janbro