Finding and showing new pictures

wxdqz

New Member
Hi, I have set up a table in a database like as follows

ID |Name | Picture | Uploaded | New |
12 |Party1 |125625.jpg |2001-09-05 |2001-09-15 |
13 |Party2 |125626.jpg |2001-09-06 |2001-09-16 |
14 |Party1 |125627.jpg |2001-09-06 |2001-09-16 |

etc厖
These are not all the columns but I think there all I need to show you.

I am trying to get it to show on a main page the name of all the pictures that have a date in the new column greater than today抯 date. So it would show the following:

Party 1 2 New Picture(s)
Party 2 1 New Picture(s)

I cant seem to get it to work any ideas would be helpful

Thanks
Dashe
 
Back
Top