www.webdeveloper.com
Results 1 to 3 of 3

Thread: mysql simple question

  1. #1
    Join Date
    Jun 2009
    Posts
    4

    mysql simple question

    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??
    Last edited by ketav; 06-21-2009 at 09:11 AM.

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    sounds like you should have a separate table, where each row represents a gun.
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

  3. #3
    Join Date
    Jun 2009
    Posts
    4
    thanx

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles