updating db with odbc

[mouse]

is there a special setting or something that i need to set to update my database? my odbc connection works....

if not - im using access2k, an apache server, and php4.2.something, and here is my code, the errors of which i would greatly appreciate knowing about:

print "<INPUT type=checkbox name=box value=1> Checkout";

if ($box == 1)
{
if (!$connect = odbc_connect('db', '', ''))
{
print "did not connect.";
}
else {
print "connected";

$result = odbc_exec($db, "INSERT INTO TEST ([name], [ctime], [rtime], [rnum], [date]) VALUES ($name, $time, $return, $numb, $date)");
$query = ("INSERT INTOTEST ([name], [ctime], [rtime], [rnum], [date]) VALUES ($name, $time, $return, $numb, $date)");
$result = odbc_exec($query);

$odbc_close($conn);
}//end else

}//end main if

[barand]

You have connected and stored the connect resource in $connect.

Your odbc_exec should then use that variable, not $db which has appeared from nowhere!

odbc_exec($connect, "SQL query string");

[mouse]

i see, i cleaned up my messy code, and remembered that php is not c++ and that my problem was that i needed to use forms. thanks!