Project Detail

Description

what I am needing is simply a few query statements, and a simple smarty template built.

template includes NO GRAPHICS work, simply a table dynamic in rows and colums (determined a mysql table/field), I can do that easy enough.

I am looking for someone to write the loops to build the grid in the predetermined number wide / down.

basically for images, and I want 1 additional thing simply include lightbox for full view of image (thumbnails at 52x52)

I'm looking for nothing fancy just the bare basics. if you can provide the demo even better. but I'm not to worried.

and then to save me some time for tomorrow:

the following MySQL queries all simple but just to speed my day up:

I have the following table:
Field Type Null Default
id int(6) No
NEWSITEMDATE date No 0000-00-00
NEWSTITLE tinytext No
NEWSSHORTDESC tinytext Yes NULL
NEWSBODY mediumtext No
NEWSITEMACTIVE tinyint(1) No 0


I want the following queries:
1) select the newest X events (1 - 9) by date NOT by ID
2) select all events for a given month (ie all for 2005-03-**)
3) select all events for a given year



that's it for this project.
another simple and straight forward project.

I'm assuming 5 - 10 for the queries (only about 15 - 20 min work max)
template should not be to bad either I'm assuming that someone has this already done. I'm NOT looking for a Gallery script just the template (no text / caption it is strictly the image).

I am not worried i you don't have the lightbox portion, but if you don't let me know in your bid.

will select someone within the hour.