Does this code mean what i think it does?

[PHPFAN10]

Hello

 

Newbie to the forum here and found you via Google, looks like a great site and forum hence why i registered and to get help when needed.

 

Can someone please tell me if the following code means if the query fails in anyway like when updating DB or any other failure it will display the error message else if query updated successfully it will go to else and continue as normal?

 

Reason i ask as not sure if it means if update query fails display error else query ok so continue or it will fail if it cannot connect to db or typo in query itself?

 

I think it would fail if any mysql error happens on query but not sure if it means would go to error if failed on anything or just certain things.

 

Thanks for any help. I know it's not the full code but it's this part i want to understand.

 

 
# Databse query
$query = mysql_query("SELECT id, admin, username, first_name, last_name, email
               FROM `users` WHERE username = '$username' AND
               password = '$password' LIMIT 1");

# Check login query
if(!$query){
        echo 'Oops';
} else {
        echo 'Done!';       
}   

[TOA]

You are correct. If there is no result from the query, which would encompass any of those failures you mentioned, it would say Oops

[PHPFAN10]

Thanks for the super quick reply. I thought it would display oops if any mysql error happened but was not sure, well am now of course because of your help

 

SOLVED

 

Thanks

PHPFAN2010

[dendic]

Jes,you are correct...If there is no result from the query, which would encompass any of those failures you mentioned, it would say Ops,Ops...