Josh...I think I want to try this on my test board this weekend.
So this requires adding that field to the database. I would have to do that, I guess, via the phpadmin tool that the website provides, and THERE the potentially relevant things appear to be:
1) the box for running queries, or
2) the place for creating a new table, where there are entry boxes for the table and the field(s) (all the latter in one box, I guess)
Is 2) where I would do something? e.g., naming an existing table and puttin gin the new field?
However, your code appears to be more in the form that I think I've seen recommended to people for running queries.
IS there a simple guide to where one does "easy" things like this, where the code is already provided to us?
Thanks - Tony
PS and I understand the bit about backing up the database first, except that I have no way of knowing whether the backups are usable...so many diverse things mentioned. I have been using the following:
- I select the tables to be backed up (in this case, I guess I select ALL, since we are altering the database)
- I check structure and data
-I check complete inserts
- I check send
and I hit "Go"
I would select one of the zipped options, except I've gotten 2 stories on which, AND I've found the only actually free zip program I could find didn't handle g or b zipped...guess I ought to spring for winzip, huh?
To take this a bit further, how can I check whether the backups are really valid? I do have a test board, so I guess I could use the backup from my main board, and maybe change all the tablename prefixes, and then go through the restore process on my testboard. Would that work??
