[Tord]

I suggest you to read this first:
https://sampwiki.blast.hk/wiki/MySQL#mysql_query

It's necessary in all queries used without threading, to clear the cache after being used. In the first code snippet you posted, I can't see any active "Cache". Example of assigning cache to a variable:

PHP код:

new Cache:varname
varname = mysql_query.....
//when done with the operations, do this:
if(cache_is_valid(varname)
{
    cache_delete(varname);
} 


. So first, get that sorted out - by deleting the cache when done.

In order to check the database - it seems your query is correct. Try with the cache stuff I mentioned and see if it solves your problem.


Secondly, if you want the reg to be above 1000 and below 10000 - do this:

PHP код:

new registration= random(8999) + 1000 


This will always meet the criteria-