[SOLVED] Will not write into Database:

[mikelmao]

My query doesnt save into the DB.. here it is:

 

                   <?php include 'connect.php';
                    if($_SERVER['REQUEST_METHOD'] == 'POST')
                    {
                      if($_POST['fname'] == "" || $_POST['lname'] == "" || $_POST['uname'] == "" || $_POST['pass'] == "" || $_POST['pass2'] == "" || $_POST['mail'] == "" || $_POST['birth'] == "")
                      {
                        echo "Please fill in all the fields before continuing";
                        echo "<meta http-equiv=Refresh content=2;url='order.php'>";
                      }
                      elseif($_POST['pass'] != $_POST['pass2'])
                      {
                        echo "The 2 passwords do not match";
                        echo "<meta http-equiv=Refresh content=2;url='order.php'>";
                      }
                    else
                    {
                    mysql_query("INSERT INTO order (fname, lname, uname, pass, mail, birth, plan, time) VALUES ('" . $_POST['fname'] . "', '" . $_POST['lname'] . "', '" . $_POST['uname'] . "', '" . $_POST['pass'] . "', '" . $_POST['mail'] . "', '" . $_POST['birth'] . "', '" . $_POST['plan'] . "', '" . $_POST['time'] . "')");
                    echo "Thank you for ordering at CXHosting, We will review your application within 48 Hours. You will recieve an email when your application has been aproved";
                    }
                    }
?>

Connect.php=

<?php
$con = mysql_connect('localhost','****','*****');  
if (!$con)
  {
    echo "Connot connect.";
  }
mysql_select_db('***********' ,$con);
?>

it all exists.. I dont get any MYSQL Errors.... Please help.. thanks

[mikelmao]

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 'order (fname, lname, uname, pass, mail, birth, plan, time) VALUES ('jlhkjkgjhfg'' at line 1

Thats the error

[mikelmao]

anyone know how to fix this problem? :'(

[elflacodepr]

try this:

 

mysql_query("INSERT INTO order (fname, lname, uname, pass, mail, birth, plan, time) VALUES ('$_POST['fname']' , '$_POST['lname']' , '$_POST['uname']', '$_POST['pass']', '$_POST['mail']', '$_POST['birth']', '$_POST['plan']', '$_POST['time']"')");

[mikelmao]

nope same error :'(

[revraz]

ORDER is a MySQL reserved word.  Either change the table name or use `backticks` around it.

[fenway]

And if that doesn't work, show us the actual error.