[Pizzy]

Here is an easier query than all of the above answers:

pawn Код:

format(sqlquery,sizeof(sqlquery),"SELECT Fines FROM Accounts WHERE Username='%s'",NameEntered);
mysql_query(sqlquery);
mysql_store_result();
new PFines = mysql_fetch_int();
mysql_free_result(); //Always have mysql_free_result() after a mysql_store_result().

I hope that is easier for you to understand.