how to write a query for ads

[shabnam]

HI,

I want to write a query for displaying ads.Ads may be many but all advertisements should not be displayed on the web page.only according to the date that particular ad should appear on the web page.please guide me in writing the query for my above doubt.please help me out.Hope i'll get my answer soon.
Thanking you,

[debasisdas]

So far my knowledge is concerned to display images in web pages something like add rotator is used . and some XML file is passed as the argument file to dynamically change the add file path and frequency.

SO what you can do is retrieve the file path from database and store in XML file and use that file for dynamically changing the ads.

[AramAz]

HI,

I want to write a query for displaying ads.Ads may be many but all advertisements should not be displayed on the web page.only according to the date that particular ad should appear on the web page.please guide me in writing the query for my above doubt.please help me out.Hope i'll get my answer soon.
Thanking you,

ok, Let's suppose your database contains this table:
Table : ad (advertiserID,advertiserBanner,startingDate,finish ingDate)

One way is to list all the ads that contain today's date (if you're changing the advertisement every 24 hours) and then show the resulted records accordingly.

An example query would be:

select * from ad 
where curdate() between startingDate and finishingDate
 

The function curdate() returns the current Date. This is mysql function.

Regards,
Aram Azhari