SQL

[Anubhav]

executeSQLQuery("SELECT * FROM BoDGroupTurf WHERE Group=?", playerGang) 

Whats wrong with this? It says

Database Query Failed: near "Group":syntax error

[Mr_Moose]

It's obviously a syntax error, SQL queries are case sensitive so it could be as simple as a misspelled word. You may find some more help in it's documentation, https://wiki.multitheftauto.com/wiki/ExecuteSQLQuery

[Anubhav]

No nothing's wrong in spelling.

EDIT:

If you want proof:

  
executeSQLQuery("CREATE TABLE IF NOT EXISTS BoDGroupTurf ( Group TEXT, Count INT )") 
  

This Is Where i create table

[Anubhav]

I realy need help this is urgent very urgent!

[#DRAGON!FIRE]

executeSQLQuery( "SELECT * FROM BoDGroupTurf WHERE Group=?", playerGang ) 

[Anubhav]

Found one more error:

  
executeSQLQuery("CREATE TABLE IF NOT EXISTS BoDGroupTurf ( Group TEXT, Count INT)") 
  

Same as I told. Whats going wrong/

EDIT: By using db functions this works fine.

[#DRAGON!FIRE]

executeSQLQuery( "CREATE TABLE IF NOT EXISTS BoDGroupTurf ( Group, Count )" ) 

[Saml1er]

Its SQL, you might've screwed up the table so simply drop this table and create a new one.

[Anubhav]

I'm just using another method tables for this thing. Its realy hard with SQL...

[Saml1er]

I'm just using another method tables for this thing. Its realy hard with SQL...

SQLite is very easy to use. I also had this kind of problem. So I just changed table name and everything was fixed. : )

[Mr_Moose]

The keywords 'Group' and 'Count' may be reserved, have you tried giving them another name, just pick something random.

[Anubhav]

Now its not needed I solved the problem without using this SQL.