[RESOLVED] Delete query not working as expected

[j_w_Bruce]

Hello again. I have 2 different php forms. One makes sure that a user has chosen an unique user name (below):
$query_rsApp = "SELECT * FROM users where UserName=".$Registered." ";

This Select query works right every time (as far as I can tell).

However,

I have a form that I want to use to delete user records. This Delete query works fine if the username and password are both numeric... But if the username or password is text, it returns the error "UNKNOWN FIELD 'whatever'" where whatever is my search criteria that I am trying to use.

$query_App = "DELETE FROM users where UserName=".$UserName." and Password=".$Password." ";

Thanks for any ideas.
JB

[NogDog]

You need to quote your string values within the query. Something like this should work:

$query_App = "DELETE FROM users where UserName='$UserName' and Password='$Password'";

[j_w_Bruce]

I tried about everything but that to get some quotes around it.

Thanks!