Jump to content

Archived

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

tjhilder

trying to view parts of table data

Recommended Posts

I'm trying to create a events page on my site where things are listed by year, month and then in the months section it shows all the events one by one in days.

 

something like this

 

-----------------

 

event year |

event_month |

event_day |  event_title | event status

event_day |  event_title | event status

event_day |  event_title | event status

 

event year |

event_month |

event_day |  event_title | event status

event_day |  event_title | event status

event_day |  event_title | event status

 

i figured it was to be displayed like this:

$query = "SELECT * FROM events WHERE event_year='2006'";

 

but it doesn't work so I guess that idea isn't correct.

 

any suggestions?

 

--

TJ

 

Share this post


Link to post
Share on other sites

im not sure if youre doing this already, but you have to actually execute the query.. ex

 

$event = mysql_query($query);

Share this post


Link to post
Share on other sites
im not sure if youre doing this already, but you have to actually execute the query.. ex

 

$event = mysql_query($query);

316545[/snapback]

yea I was already, was just posting the code where I thought it needed changing.

 

Share this post


Link to post
Share on other sites

I figure it would work like a forum does, take this forum, you have your categories, and then the categories have forums, maybe this is how I am supposed to do this script? but I not sure how I would go about making it as I'm new to MySQL (although I think i'm picking it up fairly quickly.)

 

any suggestions on what I can do?

Share this post


Link to post
Share on other sites

×

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.