HOSSEINONLINE7
سه شنبه 14 شهریور 1391, 20:11 عصر
سلام من چندین ساعته دارم به این کوئری ور میرم ولی آخرش یکجا خطا میده:افسرده: نمیدونم مشکل کجاست دوستان لطفا این کوئری من را یک نگاه بندازید ببینید مشکل من چیه :
if(isset($_POST['submit']))
{
$source=$_POST['source'];
$destination=$_POST['destination'];
$doc=time();
$dom=$_POST['date of move'];
$tom=$_POST['time of move'];
$status=$_POST['status'];
$driver=$_POST['driver'];
$model=$_POST['model'];
$price=$_POST['price'];
mysql_set_charset('utf8',$con);
$sql="insert into total service('source','destination','date of create',
'date of move','time of move','status','driver','model','price')values('$s ource','$destination',
'$doc','$dom','$tom','$status','$driver','$model')";
mysql_query($sql,$con)or die(mysql_error());
و خطایی که میده اینه :
Notice: Undefined index: date of move in F:\xampp\htdocs\bolbolsafar\add.php on line 16
Notice: Undefined index: time of move in F:\xampp\htdocs\bolbolsafar\add.php on line 17
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 'service('source','destination','date of create', 'date of move','time of move',' at line 1
if(isset($_POST['submit']))
{
$source=$_POST['source'];
$destination=$_POST['destination'];
$doc=time();
$dom=$_POST['date of move'];
$tom=$_POST['time of move'];
$status=$_POST['status'];
$driver=$_POST['driver'];
$model=$_POST['model'];
$price=$_POST['price'];
mysql_set_charset('utf8',$con);
$sql="insert into total service('source','destination','date of create',
'date of move','time of move','status','driver','model','price')values('$s ource','$destination',
'$doc','$dom','$tom','$status','$driver','$model')";
mysql_query($sql,$con)or die(mysql_error());
و خطایی که میده اینه :
Notice: Undefined index: date of move in F:\xampp\htdocs\bolbolsafar\add.php on line 16
Notice: Undefined index: time of move in F:\xampp\htdocs\bolbolsafar\add.php on line 17
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 'service('source','destination','date of create', 'date of move','time of move',' at line 1