Jump to content

trying to view parts of table data


tjhilder

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

 

Link to comment
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?

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.