mostafatalebi Posted December 6, 2012 Share Posted December 6, 2012 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? Quote Link to comment https://forums.phpfreaks.com/topic/271693-each-user-a-row-or-an-entire-table/ Share on other sites More sharing options...
kicken Posted December 7, 2012 Share Posted December 7, 2012 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. Quote Link to comment https://forums.phpfreaks.com/topic/271693-each-user-a-row-or-an-entire-table/#findComment-1398014 Share on other sites More sharing options...
mostafatalebi Posted December 7, 2012 Author Share Posted December 7, 2012 Thank you man...exactly Quote Link to comment https://forums.phpfreaks.com/topic/271693-each-user-a-row-or-an-entire-table/#findComment-1398080 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.