SQL Help

[Ohk4y]

Hello there!

I did some research and finally figured out how to create a table with SQL Explorer, as well as make some columns and rows. I have a table that has Accounts as the name that has some columns that display:

PHP Code:

rowid Username Password EZ Level X Y Exp 


If I go to the Execute SQL tab and type in:

PHP Code:

SELECT Username,Password,EZ,Level,X,Y,Exp FROM Accounts 


and it outputs with some information that I manually typed in:

PHP Code:

3 rows returned
|Exp|EZ |Level         |Password|Username|X |Y |
------------------------
|56 |975|forest_test.nw|Test1   |Ohk4y   |30|30|
|80 |200|forest_test.nw|Test1   |Test    |28|31|
|0  |0  |0             |0       |Player  |0 |0 | 


My question here is; How can I request information from the table with a Weapon Script? Also, How could I write information, as well as add rows to it with a Script.

Thanks,
Ohk4y