SA-MP Forums Archive
mysql problem - 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 problem (/showthread.php?tid=312069)



mysql problem - fordawinzz - 19.01.2012

Hello, I'm having a problem with MySQL.. so.. when I use this QUERY:
Код:
SELECT * FROM `cars` WHERE `id` < "#MAX_PCARS" ORDER by id
it will work correct and the result frees. Otherwise, if I use this:
Код:
SELECT * FROM `cars` WHERE `id` > 163
it won't work and the result wont free:
Код:
[22:11:01] CMySQLHandler::Query(SELECT * FROM `cars` WHERE id > 163) - Successfully executed.

[22:11:01] >> mysql_store_result( Connection handle: 1 )

[22:11:01] CMySQLHandler::StoreResult() - Result was stored.

[22:11:01] >> mysql_num_rows( Connection handle: 1 )

[22:11:01] CMySQLHandler::NumRows() - Returned 1 row(s)

[22:11:01] >> mysql_fetch_row_format( Connection handle: 1 )

[22:11:01] CMySQLHandler::FetchRow() - Return: 164|411|-2051.67|91.3433|28.619|94|-1|-1|Dealership|Infernus|15000000|Dealership|1|0|0|0|0



Re: mysql problem - fordawinzz - 20.01.2012

bump...