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 |
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 |
tyler.watkins |
Apr 10 2012, 03:24 PM
Post
#1
|
Novice Group: Members Posts: 27 Joined: 6-March 12 Member No.: 16,654 |
<?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! |
Brian Chandler |
Apr 11 2012, 02:07 PM
Post
#2
|
Jocular coder Group: Members Posts: 2,476 Joined: 31-August 06 Member No.: 43 |
Whichever book you're using. (I suppose it might be an online tutorial)
Incidentally there's a very delicate question: should you call the table "users" (because it's something that holds all the users, or "user", because what you get from it is a table row representing a user. I tend to think the singular is better... |
Lo-Fi Version | Time is now: 26th September 2024 - 09:25 AM |