简单的MySQL查询显示错误

Question

I am trying to execute the following query

DROP TABLE IF EXISTS `developer_messenger`;
CREATE TABLE `developer_messenger` (
  `id` int(10) NOT NULL,
  `title` varchar(45) NOT NULL,
  `username` varchar(45) NOT NULL,
  `message` varchar(45) NOT NULL,
  `type` varchar(45) NOT NULL,
  `date_time` varchar(45) NOT NULL,
  `status` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

But this simple query is showing me Error in PHP

Could not get data: 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 'CREATE TABLE developer_messenger ( id int(10) NOT NULL, title varchar(' at line 1

I am a newbie, Sorry if its silly,

Help Appreciated!

Answer 1

In Response to your second question about magic_quotes:

if (!get_magic_quotes_gpc()) { //checks php ini if magic_quotes is not on
$title = addslashes($_POST['title']);  
}
else
{
$title = stripslashes($_POST['title']); 
}

addslashes(); http://php.net/manual/en/function.addslashes.php

stripslashes(); http://php.net/manual/en/function.stripslashes.php

not sure if this helps but it might that way you dont have to change php.ini just the $data that is to be entered into sql