[Ronaldo_raul™]

Hello, I've been scripting in MySQL since 3 days. I've learnt the basic things, but now I want to expertise my MySQL coding skills. Since, MySQL is a great saving system, I am finding ways to expertise it. What I want to know is what silly mistakes people makes that aren't to be made. So, basically can anyone give me a guide through how can I optimise my MySQL codes. How to and where to properly use some functions like -

pawn Код:

mysql_free_results () ;

and another things like -
should we really do things like this -

pawn Код:

mysql_query ( "UPDATE `user` SET a=1 , b=2 WHERE `Name` = '%s'" ) ;

OR

pawn Код:

mysql_query ( "UPDATE user SET a=1 , b=2 WHERE Name = '%s'" ) ;

Where to use [``] and where not to ?
Maybe a deep knowledge and guide can help me.

Thank you.

Obediently,
Ronaldo_raul