unable to login in php mysql

[iam4423]

i dont think it will be causing your problem but you dont need

Code: Select all

mysql_query($sql,$con)

Code: Select all

mysql_query($sql)

will get the job done!

there are a few things i would try to resolve this issue firstly put your table and field names inside ` `

Code: Select all

$sql="SELECT * FROM `user` WHERE `LoginName`='$myusername' AND `Password`='$mypassword'";

and if all else fails extract your query from phpmyadmin and then just add your php variables to that. the amount of times ive not been able to work out what was wrong with my query and ive extracted it and still not been able to tell the difference but its worked anyway!

[freshnet]

The first thing to do is echo back your query and put that into phpmyadmin to see if it runs. Usually that will give you the error, if it isn't obvious just from looking at the echoed query.

Also, you should switch from using mysql to mysqli/PDO as mysql is not secure.

[NigelRen]

The error your getting is quite specific - the table doesn't exist. Have a look at your database and check that the there is in fact a table called 'user' in the schema you've specified.