Help
Posted: Thu Oct 06, 2011 10:39 am
Hi Please help!
can someone please why this code not working.
<?php
$host="Localhost";
$username="root";
$password="root";
$db_name="bbs";
$tbl_name="t_board";
mysql_connect('Localhost', 'root', 'root') or die("Unable to Connect");
mysql_select_db("bbs") or die("Unable to select DB!");
$index=$_POST['index'];
$writer=$_POST['writer'];
$subject=$_POST['subject'];
$message=$_POST['message'];
$filename=$_POST['filename'];
$sql = "UPDATE INTO t_board
SET writer='$writer', 'subject='$subject', message='$message', 'filename='$filename'
WHERE index='$index'";
$result = mysql_query($sql);
if(!$result){
echo "Query NOT WORKING"; <---- QUERY NOT WORKING
exit;
}
if ($result){
header("Location: view.php");
}
else{
echo "Please Try Again!";
echo "<BR />";
echo "<a href='view.php'> BACK </a>";
}
mysql_close();
?>
can someone please why this code not working.
<?php
$host="Localhost";
$username="root";
$password="root";
$db_name="bbs";
$tbl_name="t_board";
mysql_connect('Localhost', 'root', 'root') or die("Unable to Connect");
mysql_select_db("bbs") or die("Unable to select DB!");
$index=$_POST['index'];
$writer=$_POST['writer'];
$subject=$_POST['subject'];
$message=$_POST['message'];
$filename=$_POST['filename'];
$sql = "UPDATE INTO t_board
SET writer='$writer', 'subject='$subject', message='$message', 'filename='$filename'
WHERE index='$index'";
$result = mysql_query($sql);
if(!$result){
echo "Query NOT WORKING"; <---- QUERY NOT WORKING
exit;
}
if ($result){
header("Location: view.php");
}
else{
echo "Please Try Again!";
echo "<BR />";
echo "<a href='view.php'> BACK </a>";
}
mysql_close();
?>