SQL Problem...

Thread Rating:

0 Votes - 0 Average
1
2
3
4
5

Threaded Mode \| Linear Mode SQL Problem...
Author	Message

Coruja

Sphere Developer

Posts: 987
Likes Given: 5
Likes Received: 226 in 187 posts
Joined: Jul 2012
Reputation: 7

Dimension Shard

Post: #4

RE: SQL Problem...

you must use the arguments in correct order, you wrote SELECT [a] FROM WHERE [b] [c] but the correct is SELECT [a] FROM [b] WHERE [c]

Code:

DB.QUERY "SELECT * FROM myrunuo_characters_skills WHERE char_id='<UID>' LIMIT 1

IF (<DB.ROW.NUMROWS>)

  FOR 1 49

    DB.EXECUTE "UPDATE myrunuo_characters_skills SET skill_id=<dLOCAL._FOR>, skill_value=<I.<LOCAL._FOR>> WHERE char_id=<UID> LIMIT 1"

  ENDFOR

ELSE

  FOR 1 49

    DB.QUERY "INSERT INTO myrunuo_characters_skills (char_id, skill_id, skill_value) VALUES ('<UID>', '<dLOCAL._FOR>', '<I.<LOCAL._FOR>>')"

  ENDFOR

ENDIF

(This post was last modified: 09-12-2015 08:45 AM by Coruja.)

09-12-2015 03:29 AM

« Next Oldest | Next Newest »

Messages In This Thread

SQL Problem... - admin_teclis - 09-12-2015, 12:33 AM

RE: SQL Problem... - azmanomer - 09-12-2015, 12:54 AM

RE: SQL Problem... - admin_teclis - 09-12-2015, 01:57 AM

RE: SQL Problem... - Coruja - 09-12-2015 03:29 AM

RE: SQL Problem... - admin_teclis - 09-17-2015, 08:12 AM

RE: SQL Problem... - Artyk - 09-17-2015, 05:44 PM

RE: SQL Problem... - Extreme - 09-17-2015, 12:15 PM

User(s) browsing this thread: 4 Guest(s)