Quote:
Originally Posted by Backstabnoob
No, why? Just create a table such as:
Code:
CREATE TABLE table_itemlist (
authid VARCHAR ( 34 ),
itemid SMALLINT ( 5 ) UNSIGNED,
unixtime INT( 11 ),
INDEX( authid )
)
Then you can freely put any data in it. In the end you'll have something like this:
Code:
+------------------+--------+---------------+
| authid | itemid | unixtime |
+------------------+--------+---------------+
| STEAM_0:1:12345 | 1 | 1415781811 |
| STEAM_0:1:12345 | 2 | 1415781848 |
| STEAM_0:1:12345 | 3 | 1415781875 |
| STEAM_0:1:12345 | 5 | 1415781654 |
| STEAM_0:1:45678 | 1 | 1415781823 |
| STEAM_0:1:45678 | 3 | 1415781835 |
| STEAM_0:1:91234 | 1 | 1415787551 |
+------------------+--------+---------------+
|
But how do I handle the content if I want something like this :
Code:
+------------------+--------+---------------+
| authid | itemid | unixtime |
+------------------+--------+---------------+
| STEAM_0:1:12345 | 1,4,6 | 1415781811, 1415781215, 1415781856 |
| STEAM_0:1:12345 | 2 | 1415781848 |
| STEAM_0:1:12345 | 3 | 1415781875 |
| STEAM_0:1:12345 | 5 | 1415781654 |
| STEAM_0:1:45678 | 1 | 1415781823 |
| STEAM_0:1:45678 | 3 | 1415781835 |
| STEAM_0:1:91234 | 1 | 1415787551 |
+------------------+--------+---------------+
People can have multiple items at once.
__________________