Problem with Loop/Mysql - Printable Version

Problem with Loop/Mysql - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Problem with Loop/Mysql (/showthread.php?tid=256533)

Problem with Loop/Mysql - pr0bl3mk1nd - 21.05.2011

Hello

,
i ve the following problem: i want to load 2 houses from my mysql database, but only 1 house is loading, instead of 2.
and when the second row is "fetching", a mysql error accrues in the server log.
i use strickenkid's mysql plugin.

PHP код:



Error (0): Function: mysql_store_result called when no result stored.

PHP код:



format(query, sizeof(query), "SELECT * FROM user_houses WHERE houseOwnerID > 0"); // Query is alright

mysql_query(query, -1, -1, MySQL);

mysql_store_result(MySQL);

while (mysql_fetch_row(value, "|", MySQL))

{

     // ...

}

Re: Problem with Loop/Mysql - pr0bl3mk1nd - 22.05.2011

Push! :/