i keep getting this error no matter what format I use in updating the database.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''inbox' SET delete = '1' WHERE mailID = '218'' at line 1
the tabels i have are
Trevors4_MTD
inbox
lastonline
members
photos
Inbox culloms are
date text latin1_swedish_ci No
touser text latin1_swedish_ci No
fromuser text latin1_swedish_ci No
sub text latin1_swedish_ci No
msg text latin1_swedish_ci No
read text latin1_swedish_ci No
reply text latin1_swedish_ci No
delete text latin1_swedish_ci No
mailID int(1) No auto_increment
date2
ANY HELP?
<?
ini_set("session.cookie_domain"," .mytowndate.com");
session_start();
$myusername = $_SESSION['username'];
$mailID1 = $_GET["mailID"];
$host="localhost"; // Host name
$dbusername="**********"; // Mysql username
$dbpassword="********"; // Mysql password
$db_name="trevors4_MTD"; // Database name
$tbl_name="inbox"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$dbusername", "$dbpassword")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$a = "1";
$sql = "UPDATE 'inbox' SET delete = '1' WHERE mailID = '$mailID1'; ";
mysql_query($sql)
or die(mysql_error());
header( 'Location: http://****************') ;
?>