Click to See Complete Forum and Search --> : mysql simple question


ketav
06-21-2009, 10:04 AM
I am stuck .
I need to have a row different number of columns .Is it possible.
or any other method to solve the following problem.

Like in any in a game user starts with only 1 gun it has some properties(more than one) and the user can win more than one guns .But the problem is at any time all the users playing will not have same number of guns.So i don't want to add columns in every row because columns in other rows will be empty.

What about making different tables for every user!!!
does it slows down server in any way??

chazzy
06-21-2009, 11:55 AM
sounds like you should have a separate table, where each row represents a gun.

ketav
06-23-2009, 01:24 PM
thanx