Jump to content


Photo

Each User A Row Or An Entire Table?


  • Please log in to reply
2 replies to this topic

#1 mostafatalebi

mostafatalebi

    Advanced Member

  • Members
  • PipPipPip
  • 197 posts

Posted 06 December 2012 - 06:46 PM

Hello everybody
I'm designing an online translation-services site, and a question is just wandering around my head:

May I make a table for each translator respectively? because I want the translator to be able to see all her/his records, payments and more...

Can anybody give me a comprehensive explanation of such process?
Visual Effects Programming

Autodesk Maya, Autodesk Mudbox, Nvidia Mental Images Mental Ray, Adobe Photoshop, Adobe Illustrator, Adobe After Effects, CorelDraw

#2 kicken

kicken

    Wiser? Not exactly.

  • Gurus
  • 2,674 posts
  • LocationBonita, FL

Posted 06 December 2012 - 07:06 PM

You'd have a table for all your translators, and a table for records, another for payment, etc.  Each record/payment row would contain the ID of the user it belongs to, then when you query for a user's stuff just include a WHERE UserId=$CurrentUserId in the query to limit the results to only their records.

Recycle your old CD's, don't trash them!
Did I help you out?  Feeling generous? I accept tips via Paypal or Bitcoin @ 14mDxaob8Jgdg52scDbvf3uaeR61tB2yC7

#3 mostafatalebi

mostafatalebi

    Advanced Member

  • Members
  • PipPipPip
  • 197 posts

Posted 07 December 2012 - 06:47 AM

Thank you man...exactly
Visual Effects Programming

Autodesk Maya, Autodesk Mudbox, Nvidia Mental Images Mental Ray, Adobe Photoshop, Adobe Illustrator, Adobe After Effects, CorelDraw




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com