retrieving from database

vinayex2

i am building a website with A.M.P and currently stuck on the login system ,using mysql database and cannot retrieve data from it using POST method
and mysql query is

 
'SELECT user_fname FROM user WHERE user_idname="'.$_POST['name'].'" && user_pass ="'.$_POST['pass'].'"

but the database doesnt return anything in mysql_num_rows($result)
PLEASE HELP

vinayex2

i used the query
'SELECT user_idname FORM user WHERE user_idname ="'.$user.'" && user_pass ="'.$pass.'";
PLEASE HELP

bradgrafelman

vinayex2;10926724 wrote:
i used the query
'SELECT user_idname FORM user WHERE user_idname ="'.$user.'" && user_pass ="'.$pass.'";

Did you actually copy-and-paste that code directly from your script? If so, you have a parse error - missing quote at the end.

vinayex2

bradgrafelman;10926748 wrote:
Did you actually copy-and-paste that code directly from your script? If so, you have a parse error - missing quote at the end.

No the query doesnot return a parse error its just that the database cannot retrieve anything
ive checked by echoing the query
it seems right
Can u help