Help with MYSQL, Avoid Dual Records?
#4

Quote:
Originally Posted by almighty
Посмотреть сообщение
Thanks... its working.... it seems... i saw the tutorial on you sig... gonna use it.... :P... if you dont mind me asking these, there are a few funtions i dont really get... like... the "mysql_real_escape_string"... What is it for?... or whats the result stored on Mysql_store_result?... also... The part were you do the mysql_num_rows... it checks if in the database, from the query, has been found rows?
MySQL_Escape_Query makes it so that players cannot SQL inject because if they do it could delete your whole table.

MySQL_Store_Result is just storing the information that you are trying to retrieve from the database.

MySQL_Num_Rows is checking how much rows the stored result returned. I made it more than 0 because if the mysql connection is down it's -1 and if there is no existing rows then it is 0.

For more information visit https://sampwiki.blast.hk/wiki/MySQL
Reply


Messages In This Thread
Help with MYSQL, Avoid Dual Records? - by almighty - 04.10.2010, 22:27
Re: Help with MYSQL, Avoid Dual Records? - by [HiC]TheKiller - 04.10.2010, 22:35
Respuesta: Help with MYSQL, Avoid Dual Records? - by almighty - 04.10.2010, 22:52
Re: Respuesta: Help with MYSQL, Avoid Dual Records? - by [HiC]TheKiller - 05.10.2010, 01:41

Forum Jump:


Users browsing this thread: 1 Guest(s)