quote:
Originally posted by saralk
have a column called id, put one record in it, with the ID as 1, and then just run that script every time you want to update it
If there's only one row in the table, you don't need a WHERE statement in your query, because MySQL will update all the rows by default. Since there's only one row, "all" = "one."