Lopes Posted June 7, 2013 Share Posted June 7, 2013 Hi guys. Im almost dead trying to do this..somebody help me please How do i can get this: First Name | Last Name | Age | Registered ---------------------------------------------------- John | Harris | 30 | Yes Amy | Ford | 45 | No Of this tables.. Table Fields: ID | Label ---------------- 1 | First Name 2 | Last name 3 | Age Table Users: FieldID | UserID | Value ------------------------- 1 | 1 | John 2 | 1 | Harris 3 | 1 | 30 1 | 2 | Amy 2 | 2 | Ford 3 | 2 | 45 Table Registrations: UserID | Registered ------------------- 1 | Yes 2 | No Thanks in advance to all. Link to comment https://forums.phpfreaks.com/topic/278876-need-a-complicated-query/ Share on other sites More sharing options...
Jessica Posted June 7, 2013 Share Posted June 7, 2013 You didn't post what you have tried, so you're asking someone to write it for you. Link to comment https://forums.phpfreaks.com/topic/278876-need-a-complicated-query/#findComment-1434585 Share on other sites More sharing options...
Jessica Posted June 7, 2013 Share Posted June 7, 2013 Also this is OVER abstracted. All of that data should be in one table anyway. Link to comment https://forums.phpfreaks.com/topic/278876-need-a-complicated-query/#findComment-1434586 Share on other sites More sharing options...
Barand Posted June 7, 2013 Share Posted June 7, 2013 This thread should help http://forums.phpfreaks.com/topic/277085-the-eav-model-or-something-better/ Link to comment https://forums.phpfreaks.com/topic/278876-need-a-complicated-query/#findComment-1434619 Share on other sites More sharing options...
Lopes Posted June 7, 2013 Author Share Posted June 7, 2013 This thread should help http://forums.phpfreaks.com/topic/277085-the-eav-model-or-something-better/ Thanks Barand. Link to comment https://forums.phpfreaks.com/topic/278876-need-a-complicated-query/#findComment-1434633 Share on other sites More sharing options...
Lopes Posted June 7, 2013 Author Share Posted June 7, 2013 Also this is OVER abstracted. All of that data should be in one table anyway. Are you upset with something? Frustrated person.... Link to comment https://forums.phpfreaks.com/topic/278876-need-a-complicated-query/#findComment-1434635 Share on other sites More sharing options...
Jessica Posted June 7, 2013 Share Posted June 7, 2013 Are you upset with something? Frustrated person....Do you understand what I wrote? Because it was pretty much a statement of fact, not anything to do with anyone's emotions. Link to comment https://forums.phpfreaks.com/topic/278876-need-a-complicated-query/#findComment-1434719 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.