Member Avatar for jakx12

ok so here is the error: 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 'from, content, date) VALUES('', '', '', '')' at line 1 Between the apostrophes is the information from the form.

the code is this:

<?php 
SESSION_start(); 
include("dbcon.php"); 
dbcon(); 

$user = mysql_real_escape_string($_POST['user']); 
$content = mysql_real_escape_string($_POST['content']); 
$date = mysql_real_escape_string($_POST['date']); 

mysql_query("INSERT INTO wall (user, from, content, date) VALUES('$user', '$user', '$content', '$date')")  
or die(mysql_error());   
echo  "<h1>Your post was successful</h1>"; 
echo "This page will be re-directed to your wall in 5 seconds"; 
header('Refresh: 5; url=yourwall.php'); 

?>

whats wrong??

  • 2 Contributors
  • 1 Reply
  • 70 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Shanti C
Member Avatar for Shanti C

try like this:

"INSERT INTO `wall` (`user`, `from`, `content`, `date`) VALUES(.............etc.
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.