Hi
I have been trying to do something for quit some time and just cant get it. Hopefully someone will know how to do this.
I have a database of pictures and when I add a picture I put the name of the picture (Name), the date I want the picture to remain on the new list until (New), the group of pictures that that picture belongs to (Event Name). For example:
| Event Name | New | Name
| Galway | 2001-12-10 | pic-001.jpg |
What I want to create is a list on my home page that is as follows
Event New Total
Galway 5 12
What kind of select statement or php script do I need to use to get a count of the pictures that have a New date greater than today抯 date and also how to show the total number of pictures.
Any help is greatly appreciated
Dashe
I have been trying to do something for quit some time and just cant get it. Hopefully someone will know how to do this.
I have a database of pictures and when I add a picture I put the name of the picture (Name), the date I want the picture to remain on the new list until (New), the group of pictures that that picture belongs to (Event Name). For example:
| Event Name | New | Name
| Galway | 2001-12-10 | pic-001.jpg |
What I want to create is a list on my home page that is as follows
Event New Total
Galway 5 12
What kind of select statement or php script do I need to use to get a count of the pictures that have a New date greater than today抯 date and also how to show the total number of pictures.
Any help is greatly appreciated
Dashe