Jump to content

Need a complicated query


Lopes

Recommended Posts

Hi guys.  Im almost dead trying to do this..somebody help me please :hammer_time:

 

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.