Help with SQL query

[El Heso]

Hi!

Is it possible to make this happen?

 

$sql="SELECT CONCAT(contact) Contact, CONCAT(date) Date, 
CONCAT(p1453_01) '1. How old are you?', 
CONCAT(p1453_02) '2. Do you own a car?', 
CONCAT(p1453_03) '3. Have your friends a car?' 
FROM survey 
WHERE 
p1453_02 
like 'Yes%' ORDER BY datum DESC";

 

to this:

 

$sql="SELECT CONCAT( get value from other place ) get value from other place , CONCAT(get value from other place ) get value from other place , 
CONCAT(get value from other place ) ' get value from other place ', 
CONCAT(get value from other place ) ' get value from other place ', 
CONCAT(get value from other place ) ' get value from other place ' 
FROM survey 
WHERE 
get value from other place  
like 'get value from other place %' ORDER BY datum DESC";

 

I would like to set the value for each field from admin side of my site and then run the query

Hope you guys understand what i mean

 

Any advice?

 

Regards Tony

[gristoi]

$sql="SELECT CONCAT( get value from other place ) get value from other place , CONCAT(get value from other place ) get value from other place , 
CONCAT(t.fieldOne,"+",s.FieldTwo ) AS ' get value from other place '

FROM survey s JOIN adminTable t USING(id)
WHERE 
get value from other place  
like 'get value from other place %' ORDER BY datum DESC";

 

hope that helps