--- On Thu, 15/11/12, Priya <[email protected]> wrote:
> thank you very much for your replies > i think i have not clearly expressed my problem > i am using windows xp os with wamp server > in mysql i have created a database and a table > through php myadmin > the table is having fileds -date, pump to brg > temperature, bottom brg > temperature, vibration level and so on > through a html form iam filling these datas daily > each day values is getting stored as a row. > when a query is being given with select > statement between to dates result > is coming in rows > my doubt is whether the table can be displayed vertically ie > decription in > first column and results for firstdate in second > column and so on so that > for comparision it is easy between dates > i prayed GOOGLE GOD no result > hope i have explained my problem > i will be happy if somebody is helping me > thanks in advance > I think what you want is crosstab or xtab. Search for mysql and crosstab Raman.P blog:http://ramanchennai.wordpress.com/ _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
