tjhilder Posted November 9, 2005 Share Posted November 9, 2005 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 https://forums.phpfreaks.com/topic/2833-trying-to-view-parts-of-table-data/ Share on other sites More sharing options...
Guest Posted November 9, 2005 Share Posted November 9, 2005 im not sure if youre doing this already, but you have to actually execute the query.. ex $event = mysql_query($query); Link to comment https://forums.phpfreaks.com/topic/2833-trying-to-view-parts-of-table-data/#findComment-9501 Share on other sites More sharing options...
tjhilder Posted November 9, 2005 Author Share Posted November 9, 2005 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. Link to comment https://forums.phpfreaks.com/topic/2833-trying-to-view-parts-of-table-data/#findComment-9502 Share on other sites More sharing options...
tjhilder Posted November 10, 2005 Author Share Posted November 10, 2005 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 https://forums.phpfreaks.com/topic/2833-trying-to-view-parts-of-table-data/#findComment-9514 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.