MySQL Forums
Forum List  »  Newbie

Problem with SQL query from two tables
Posted by: Rafal Zajac
Date: August 17, 2005 12:33AM

Hi

I'm real beginner in this.
I nave two tables with columns as fallows:
table 1:
id, login_t, password_t
table 2
id, full_member

id like to ask something like this (passing two variables from a form: login and password):

show id, full_member from table_1, table_2 where login_t = login and password_t = password and table_1.id = table_2.id

so in response i get id if the login and password are correct and if the user is full_member.

Ralph

Options: ReplyQuote


Subject
Written By
Posted
Problem with SQL query from two tables
August 17, 2005 12:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.