simple select question

[iBuddy]

whats the coding if i wnat to select 2 things from a client file form a db...for example i want to search thru my database and be able to tell it to search for useranme and password so like

("SELECT * FROM auth WHERE username = '$username' and password = '$password'",$db);

how do i tell it basically AND?

[bubblenut]

with either 'AND' or '&&' if you mean in the where condition. Seperated by commas (,) if in the select.

eg

SELECT var1, var2 FROM table WHERE username='$username' && password='$password'

HTH