error in php

[JOHNYS22031990]

μου βγαζει αυτο

Parse error: syntax error, unexpected 'TABLE' (T_STRING) in C:\wamp\www\askisi\process_res.php on line 21

 

 

 

<?php   

 

$dbhost = 'localhost:3036';

$dbuser = 'root';

$dbpass = "";

$conn = mysql_connect($dbhost, $dbuser, $dbpass);

if(! $conn )

{

  die('Could not connect: ' . mysql_error());

}

echo 'Connected successfully';

$sql = 'CREATE Database RESDB';

$retval = mysql_query( $sql, $conn );

if(! $retval )

{

  die('Could not create database: ' . mysql_error());

}

echo "Database RESDB created successfully\n";

mysql_close($conn); 

 

$sql1="CREATE TABLE reservations(FirstName CHAR(30),LastName CHAR(30),Telephone INT,Email CHAR(30),Persons INT,Ttime CHAR(30),Day INT,Month CHAR(30),Arrangement CHAR(30))";

 

mysql_select_db('RESDB');

$retval = mysql_query( $sql1, $conn );

if(! $retval )

{

  die('Could not create table: ' . mysql_error());

}

echo "Table employee created successfully\n";  

 

$sql = 'INSERT INTO reservations '.

       '(serid,Name, Surname, Day,Month,persnoNo,email,arrangement) '.

       'VALUES ( '$_POST[name]','$_POST[surname]','$_POST[day','$_POST[month]','$_POST[persons]','$_POST','$_POST[arrangemant]')'; 

mysql_select_db('RESDB');

$retval = mysql_query( $sql, $conn );

if(! $retval )

{

  die('Could not enter data: ' . mysql_error());

}

echo "Entered data successfully\n";  

mysql_close($conn); 

?>

[DaRkAnGeL999]

Ρε τσακαλε μην ανοιγεις 2 φορες το ιδιο θεμα

 

http://www.insomnia.gr/topic/482821-error-in-php/