Creating a dynamic table based on a simple mysql table
Posted: Wed Jun 25, 2008 2:06 pm
Hi guys,
This is my first post on the forum. I've so far tried and tried to get my codes to work myself, and I normally do after some time.. however I probably make them very complicated for no special reason. So thought I'll try you guys for some help and examples this time..
Short what i am doing. I've inputted my google ranking for certain keywords and domains in a table that is stored in a mysql db. I now want to use php to display this is a table or a floating divs ( I guess that is my two options), to create a dynamic table. With that I mean you can decide to sort by any of the columns.
I've created a mockup in Excel of what I am trying to achieve. The picture also shows the mysql table.(see attachment)
----
MySQL table:
Name: GoogleRanking
id - int
domain - varchar
keyword - varchar
ranking - varchar
date - timestamp
-----
current - 1 week = last weeks data.
I want 10 columns showing the last 10 weeks of ranking result
Important: 1 is the highest, lowest ranking is 50.
Can anyone help me with this?
This is my first post on the forum. I've so far tried and tried to get my codes to work myself, and I normally do after some time.. however I probably make them very complicated for no special reason. So thought I'll try you guys for some help and examples this time..
Short what i am doing. I've inputted my google ranking for certain keywords and domains in a table that is stored in a mysql db. I now want to use php to display this is a table or a floating divs ( I guess that is my two options), to create a dynamic table. With that I mean you can decide to sort by any of the columns.
I've created a mockup in Excel of what I am trying to achieve. The picture also shows the mysql table.(see attachment)
----
MySQL table:
Name: GoogleRanking
id - int
domain - varchar
keyword - varchar
ranking - varchar
date - timestamp
-----
current - 1 week = last weeks data.
I want 10 columns showing the last 10 weeks of ranking result
Important: 1 is the highest, lowest ranking is 50.
Can anyone help me with this?