[HELP] SQLite queries
Good morning, I have an unsolved problem when making a query with SQLite, in the DB Browser for SQLite program the query returns normally with all the information, but when trying to perform the query in the game I get the following error:
Code:
Error: near "(": syntax errorhttps://i.imgur.com/r0DQXWO.jpg PHP Code:
PHP Code:
|
Re: [HELP] SQLite queries
PHP Code:
PHP Code:
|
Re: [HELP] SQLite queries
Quote:
Edit 1: Error code is 1.. Code:
(1) SQLITE_ERROR |
Re: [HELP] SQLite queries
Did you try same query with MySql? How i remember some functions are not possible to query with sqlite, like Auto_increment, so maybe thats the issue
|
Re: [HELP] SQLite queries
Quote:
Which leads me to think about how to count the querie lines by returning them in a column, what a boring situation... |
Re: [HELP] SQLite queries
What are you trying to do? Maybe it can be written a different way
Edit: Try this, you will need to add the few other conditions that you have. PHP Code:
Code:
"1" "20" "9" "STEAM_1"Code:
"1" "5" "STEAM_4" |
Re: [HELP] SQLite queries
Quote:
Could you give me your syntax analysis below? It would have to change the way the querie is made, since the search would be straight from the steamid table, but it was supposed to work, what do you think? PHP Code:
|
Re: [HELP] SQLite queries
Not sure I can help then.
Using the above, this will get you an individual players rank PHP Code:
|
Re: [HELP] SQLite queries
Solved with some small changes, which in this case are the filters, in the query proposed by Bugsy, thanks for the time spent.
|
| All times are GMT -4. The time now is 02:30. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.