vande28 Posted June 28, 2006 Share Posted June 28, 2006 I am currently in the process of figuring out how to write a script that will draw from a database a new picture every day in an automated fashion. Assuming that I already have the data base I just need a script that will draw the pictures from the data base and post them in a designated spot on my website. I have not yet been able to do so. If some one could point me in the right direction I would appreciate it.Thanks Link to comment Share on other sites More sharing options...
pulpfiction Posted June 28, 2006 Share Posted June 28, 2006 You can use a SQL query to randomly get a record from a DB,SQL Server Query:SELECT TOP 1 <columnname>FROM <TableName>ORDER BY NEWID()More Details.....http://www.petefreitag.com/item/466.cfm Link to comment Share on other sites More sharing options...
reportingsjr Posted June 28, 2006 Share Posted June 28, 2006 or... just pre load all of the images and pull the day, in three letter for (Sun, Mon, Tue, Wed, etc..) and do if elses? that seems like the easiest approach.. cause pictures take up a LOT of space in databases Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now