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? 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. 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 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
Archived
This topic is now archived and is closed to further replies.