mysql help? - Printable Version

mysql help? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql help? (/showthread.php?tid=596636)

mysql help? - N0FeaR - 20.12.2015

I have house system with mysql and when i use houseedit change ec the level on id 0 then is change on id 1 instead, mabye you guys can help me, thanks in advance

Re: mysql help? - vassilis - 20.12.2015

How you believe we can help you when you don't provide us with a code to fix?

Re: mysql help? - N0FeaR - 20.12.2015

Quote:

Originally Posted by vassilis

How you believe we can help you when you don't provide us with a code to fix?

sloved!

Re: mysql help? - vassilis - 20.12.2015

This house loading is wrong.
It says that i create a new variable named row;
and say that if row < rows then do that..
Example to understand the mistake.
i create a variable named test.. and then i say that if test is smaller than number 3 then do something..
Does it make sense? I guess not.
To sum up, you have to set row a number. I suggest to do that

PHP код:



for(new row =0; row < rows; row++)

Re: mysql help? - N0FeaR - 20.12.2015

Quote:

Originally Posted by vassilis

This house loading is wrong.
It says that i create a new variable named row;
and say that if row < rows then do that..
Example to understand the mistake.
i create a variable named test.. and then i say that if test is smaller than number 3 then do something..
Does it make sense? I guess not.
To sum up, you have to set row a number. I suggest to do that

PHP код:



for(new row =0; row < rows; row++)

Like this

PHP код:



for(new row =10; row < rows; row++)

Re: mysql help? - vassilis - 20.12.2015

Quote:

Originally Posted by N0FeaR

Like this

PHP код:



for(new row =10; row < rows; row++)

Not a random number but but the first house id you create for example if your first house id starts from number 1 then loop from number 1 if it starts from house id 0 then loop from number 0

Re: mysql help? - N0FeaR - 20.12.2015

Quote:

Originally Posted by vassilis

Not a random number but but the first house id you create for example if your first house id starts from number 1 then loop from number 1 if it starts from house id 0 then loop from number 0

i using this, but still same problem.

PHP код:



for(new row =0; row < rows; row++)

Re: mysql help? - N0FeaR - 20.12.2015

Nvm fixed now!