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 '' at line 7 Options

[tyler.watkins]

<?php
$mysql_host = "********";
$mysql_database = "********";
$mysql_user = "*************";
$mysql_password = "*********";


$fname=$_POST['fname'];
$lname=$_POST['lname'];
$user=$_POST['username'];
$password=$_POST['password'];
$verify=$_POST['verify'];
$email=$_POST['email'];
$country=$_POST['country'];
$month=$_POST['month'];
$day=$_POST['day'];
$year=$_POST['year'];


$con = mysql_connect( $mysql_host, $mysql_user, $mysql_password );

if ( !$con )
{
die( 'Could not connect: ' . mysql_error() );
}

mysql_select_db( "$mysql_database",$con );


$table = "CREATE TABLE `$user`
(
`fname` varchar(30),
`lname` varchar(30),
`username` varchar(30),
`password` varchar(30),
`email' varchar(30),
'country' varchar(30),
'month' varchar(30),
'day' int(2),
'year' int(4),
PRIMARY KEY '$user'
)" ;

echo "Table Created!";

mysql_query($table,$con)
or die (mysql_error());

mysql_close($con);
?>



Above is my php code. I am trying to make a login system. I keep getting this error message "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 '' at line 7"

I have no idea what this means because i have no code on line 7. Any help is greatly appreciated.

Also if you have any suggestions, please pm me.

The form for this php code is on the page "http://blocks.netne.net/register.html "

Please visit and give me any suggestions as to what to do! Thanks!

[tyler.watkins]

You lost me?

[Ephraim F. Moya]

You lost me?

first you select the database using the database's name. In this case the database name is database.

Next you use a sql query to select the data you want.

mysql_query( SELECT * FROM `table2` FOR `id` = 7 );

In English: give me all (*) the data for the row with id = 7.

What you'll get back is an array with all the data in row 7 or you'll get back a false if there's no row 7.

Study the diagram I posted. It describes a simple database like I think you want.

This post has been edited by Ephraim F. Moya: Apr 12 2012, 12:06 AM