Automatic Daily Update
Posted: Fri Nov 17, 2006 5:32 pm
I'm about to make a script that automatically updates a 'word of the day' section for a foreign language website.
I know how to create a MySQL database to store all of the words, and have a position laid out on the website in which the words will be displayed. However, I'm unsure of how to have it automatically update the word each day.
Is there a SQL command or PHP command that will automatically retrieve the next row in a database each day? I aim to use keys along the lines of 'word_id' or something, which would simply start at 1 (or 0) and continue up from there.
I know how to create a MySQL database to store all of the words, and have a position laid out on the website in which the words will be displayed. However, I'm unsure of how to have it automatically update the word each day.
Is there a SQL command or PHP command that will automatically retrieve the next row in a database each day? I aim to use keys along the lines of 'word_id' or something, which would simply start at 1 (or 0) and continue up from there.