Vice City: Multiplayer

VC:MP Discussion => Support => Topic started by: John on Oct 16, 2019, 05:16 PM

Title: Need help with MySQL
Post by: John on Oct 16, 2019, 05:16 PM
Hello, I have recently converted a SQL based gamemode to MySQL. I would like to know how the value of next row can be returned in MySQL. I know it is GetSQLNextRow in SQLite but I do not know how i can do that in MySQL. Any kind of help will be appreciated.

- John
Title: Re: Need help with MySQL
Post by: AroliS^ on Oct 16, 2019, 05:29 PM
Can you show us the function that you are converting to
Title: Re: Need help with MySQL
Post by: Simba on Oct 16, 2019, 09:06 PM
Quote from: John on Oct 16, 2019, 05:16 PMHello, I have recently converted a SQL based gamemode to MySQL. I would like to know how the value of next row can be returned in MySQL. I know it is GetSQLNextRow in SQLite but I do not know how i can do that in MySQL. Any kind of help will be appreciated.

- John
there is no function like that, if u want to get all data from table, you will have to create loop and if you want to do something else then explain in details and give us a code so i can set up that code for u
Title: Re: Need help with MySQL
Post by: Xmair on Oct 17, 2019, 05:04 PM
If I remember correctly, you just have to fetch the data X number of times where X is the number of rows returned by the query.