Board index   FAQ   Search  
Register  Login
Board index php forum :: php coding PHP coding => General

SQL query help

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

SQL query help

Postby Georgezx9 » Sat Apr 12, 2014 2:24 pm

I have the following code which is giving the following error:

( ! ) Parse error: syntax error, unexpected ';' in C:\wamp\www\process-6.php on line 18 (the select from line)

Its a simple code, Name comes from a posted form field, user-name is the field name in the table.

Clearly simple but not simple enough for me. Any help gratefully appreciated.

Code: Select all
mysql_select_db($database) or die("Error connecting to database: ".mysql_error());
       $username = $_POST['Name'];
   $query = ("SELECT * FROM Users WHERE User-Name = '$username'";
   $result mysql_query($query);
Georgezx9
New php-forum User
New php-forum User
 
Posts: 9
Joined: Mon Mar 31, 2014 1:15 pm

Re: SQL query help

Postby webmasterInTraining » Sat Apr 12, 2014 4:36 pm

it looks like you never closed your parentheses...

you have this

$query = ("SELECT * FROM Users WHERE User-Name = '$username'";

but you should close it like this

$query = ("SELECT * FROM Users WHERE User-Name = '$username'");

Plus I am not really sure why you are enclosing it with () anyhow seeing how it is a string. I am still pretty new to sql, but I believe that is the problem.
webmasterInTraining
New php-forum User
New php-forum User
 
Posts: 4
Joined: Wed Apr 09, 2014 1:45 am

Re: SQL query help

Postby seandisanti » Sat Apr 12, 2014 8:11 pm

also, User-Name is a bad field name. if you're going to do compound words use underscore. Otherwise, you have to quote the names so that it's not interpreted to be user minus name.
seandisanti
php-forum Fan User
php-forum Fan User
 
Posts: 838
Joined: Mon Oct 01, 2012 12:32 pm


Return to PHP coding => General

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.