View Single Post
WAR3DM
Senior Member
Join Date: Mar 2016
Old 09-07-2016 , 22:50   Re: [SQLite] Combining Rows like nVault
Reply With Quote #6

Each player (player_id) gets 40 separate skills (skill_id), 1 skill for each row... so the number of rows skyrocket into the hundreds of thousands.


My end result would be:
  • 1 row per player (player_id)
  • Under (skill_level), the 40 skills should be listed horizontally. (separated by a space)
  • Each skill_level number counts as the next (skill_id) in the list. (0, 1, 2, 3.. 39)


For example:


skill_id 0 = 11
skill_id 1 = 22
skill_id 2 = 33

So when I query for the 3rd skill under (skill_level) using strbreak, it will select 33.

Last edited by WAR3DM; 09-07-2016 at 23:17.
WAR3DM is offline