Thread: SQL Help
View Single Post
  #1  
Old 09-25-2011, 03:12 AM
Ohk4y Ohk4y is offline
Registered User
Ohk4y's Avatar
Join Date: Jun 2011
Posts: 43
Ohk4y is an unknown quantity at this point
Send a message via AIM to Ohk4y
SQL Help

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|||
------------------------
|
56 |975|forest_test.nw|Test1   |Ohk4y   |30|30|
|
80 |200|forest_test.nw|Test1   |Test    |28|31|
|
0  |0  |0             |0       |Player  ||
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
__________________
Reply With Quote