Hi,i have this tblProductAttribute with ProductAttributeID|ProductID|AttributeID|AttributeValue|
1|1|Blue
2|2|medium
(AttributeID 1 = Color,2= size)
i want to get result from select query like this
ProductName|Color|Size
sampleproduct|Blue|Medium
inshort i need to get row data to be the column name
please help me.thanks :-)
If you are using MS SQL you can do
SELECT column_name
FROM information_schema.columns
WHERE table_name = 'yourtablename'
ORDER BY ordinal_position
tnx for reply.but im using mysql.
select ProductID , max(case when AttributeID=1 then AttributeValue else null end) Color
, max(case when AttributeID=2 then AttributeValue else null end) Size from tblProductAttribute
group by ProductID
@urtrivedi thanks you very much! i have another question,what if i have unknown number of attributes? In my program,the user can add attributes.
You can do this by using php code,
First you have to loop through attribute table and create dynamic query.
Then exucute that query to get the desired result
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.