Jump to content

SQL _ GridList


Recommended Posts

Doesn't matter it's both .
addEventHandler('onResourceStart',getResourceRootElement ( getThisResource (    )   ), 
    function (      ) 
        executeSQLQuery ( 'CREATE TABLE IF NOT EXISTS `Like UnLike System` ( MyCoulmn[1],MyCoulmn[2],MyCoulmn[3] )' ) 
    end 
) 

You can add \ remove column .

wil remove with ?

I saw no sql lite function remove column just row .

Link to comment
You can remove it yes and add the column as what you want .

addEventHandler('onResourceStart',getResourceRootElement ( getThisResource (    )   ), 
  
    function (      ) 
  
        executeSQLQuery ( 'CREATE TABLE IF NOT EXISTS `Like UnLike System` ( PlayerName,MyCoulmn[2],MyCoulmn[3] )' ) 
  
    end 
  
) 
------------------------------------------------------------------------------------------------------------ 
  
function Results() 
    local Results = executeSQLQuery("SELECT * FROM `Like UnLike System` WHERE PlayerName=?",getPlayerName ( name ) ) 
             
            if ( Results == "table" and #Results == 0 or not Results  ) then 
             
             executeSQLQuery ( "INSERT INTO `Like UnLike System` ( PlayerName,MyCoulmn[1],MyCoulmn[2] ) VALUES(?,?,?,?)",getPlayerName(name)) 
             
            else 
             
            executeSQLQuery('UPDATE `Like UnLike System` SET MyCoulmn[1], MyCoulmn[2] PlayerName =?',?,?,getPlayerName(name)) 
             
            end 
            end 
addEvent("gResults",true) 
addEventHandler("gResults",root,Results) 

can I keep it's with [ ? ] ?

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...