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?
Each User A Row Or An Entire Table?
Started by mostafatalebi, Dec 06 2012 06:46 PM
2 replies to this topic
#1
mostafatalebi
-
- Members
-
- 177 posts
Advanced Member
Posted 06 December 2012 - 06:46 PM
Visual Effects Programming
Autodesk Maya, Autodesk Mudbox, Nvidia Mental Images Mental Ray, Adobe Photoshop, Adobe Illustrator, Adobe After Effects, CorelDraw
Autodesk Maya, Autodesk Mudbox, Nvidia Mental Images Mental Ray, Adobe Photoshop, Adobe Illustrator, Adobe After Effects, CorelDraw
#2
kicken
-
- Gurus
-
- 1,801 posts
Wiser? Not exactly.
- 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
Did I help you out? Feeling generous? I accept tips via Paypal or Bitcoin @ 14mDxaob8Jgdg52scDbvf3uaeR61tB2yC7
#3
mostafatalebi
-
- Members
-
- 177 posts
Advanced Member
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
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
