Trying to assign variable to sql resource indicator

Hi all :slight_smile:

Having some issues creating a login validation page.
Just using the basic HTML form tags, parsing username and password to the validation page.
Im using php and want to check that the password input parsed from the html form is the same as the password in the database. (I trust that makes sense).

The issue I can’t find a solution for is how I can designate a sql query result as a variable.
I realise that sql queries return a resource indicator and not data.

Is there a way I can grab the password string in my database and assign it a variable name?

Im just trying to get my head around how its working, any suggestions would be appreciated.