Noticed that there was still something missing in this: $sql = "select User_name, User_pass from user where User_name = '$_POST['user_id']' and User_pass = '$_POST['user_pass']'"; Quotes around the POST Args. George > -----Original Message----- > From: eoghan [mailto:php@xxxxxxxxx] > Sent: 20 May 2005 11:21 am > To: Rittwick Banerjee > Cc: php-general@xxxxxxxxxxxxx > Subject: Re: mysql with php > > > $sql = "select User_name, User_pass from user where User_name = > '$_POST[user_id]' and User_pass = '$_POST[user_pass]'"; > > assuming user_id isnt an int > > Rittwick Banerjee wrote: > > Hi friends, > > > > I am Rittwick Banerjee > > > > and i have made a mysql based user name and password program but I > > found that > > what ever I entered in the user name and password feild the php file > > dose not working. > > > > I set this code for user name and password > > > > $sql = " SELECT `User_name` AND `User_pass` FROM `user` WHERE > > `User_name`= '$_POST[user_id]' AND `User_pass` = '$_POST[user_pass]' " > > > > But this code dose not working properly. > > This code dosen't checking if the user name and password is correct or > > incorrect > > > > Please help me with some source code. > > > > Thank you. > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php