Hi, I'm running PHP3 on windows 98 using omnihttpd. I'm trying to update a record in a database, but for some reason it doesn't work:
<?
// connect to the database
$connect = odbc_pconnect("MyDB", "", "");
// update the info
$query = "UPDATE MyTable SET body = '".$body."' WHERE name = '".$name."'";
// debugging. unmask to print out sql query
print($query."<br>");
//peform the query
odbc_do($connect, $query);
// kill $query
$query = "";
//close the connection
odbc_close($connect);
// kill $connect
$connect = "";
?>
Can anyone see what the problem is?
Thanks