Dear Friends
Hope you all doing great.
Thanks for the replies to queries earlier. Sorry couldnt reply back, got busy working on your tips.
Now that part done. I need your help in making me the following work.
I am working on a project which is basically a Caption Contest kind of thing.
Let me explain a bit.
I need to display a page with ten or more pics.
These are thumbnails.
When someone clicks on this thumbnail next page opens up showing the large size pic
and
all the captions submitted by people.
Now I am using two tables to achieve this
Table one in which stores the location of the thumbnail and large pic and an ID_NO assigned to them.
Table Two in which I am storing the captions and other information
CAP_ID - Autonumber - Just to know how many captions have been given
PIC_ID - Number - Taken from table 1, ID_NO of the pic. To know for which pic caption was given for
Caption - Memo - To store the caption
From - Text - to store name and email
Date - Date/Time - On which date it was submitted
All Said, Now My Query
1 - When I need to show the captions on result page, I want only the caption for say PIC_1 are shown. This ID_NO I will pass from the previous page.
How can I do that
Show only the records where PIC_ID is 1 from table 2. As table 2 can have more than one entries for PIC_ID 1.
2 - Whenever in table 2 a caption is added corresponding to PIC_ID in table 1, a field named totalcaptions should increment by 1 in table 1
3 - In the date field I want whenever a record is entered, the date for that day should add automatically.
4 - Also how can I display the date in following format 14 February, 2003
Waiting for your replies.
All Things Nice And Beautiful.
Love
Lovely
==========================
========
Start Free Trial
