mysql help

[simple_man_11]

Can someone please tell me why my sql script is not working right?  It is suppose to look at two different tables and get the results.  The second table is a table that will manually be update so that only member will have access if they choose to..

 

$sql = "SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try, user_email
		FROM " . USERS_TABLE . "
		WHERE username = '" . str_replace("\\'", "''", $username) . "' 
		and  user_email = (select email from  members_list where uid = '$username') ";

[pocobueno1388]

What error are you getting?

 

this part of your query doesn't look right to me:

and  user_email = (select email from  members_list where uid = '$username')

 

I am not advanced enough to give you the correct one, sorry.

 

Add this to the end of your code:

 

$result = mysql_query($sql)or die(mysql_error());

[Barand]

Tell use the structure of the tables and exactly what you are trying to achieve. Posting code that "isn't working right" tells us nothing.