Help..Newbie here...

[wsipple]

Hi everyone..!!!

I know what I have is a simple fix, but for the life of me I can not figure out the script I need to use to make it happen..

I have a table named cubmaster
in the table is a row named announce_text.

I want to be able to post information to the announce_text row but I want to overwrite the old information..

I have tried to figure out replace, delete, and update, but they all only delete a portion of the row... I want the entire thing overwritten and posted to an html page..

Thank you for your assistance in this matter...

[Old Pedant]

Well, the *SQL* for that is simply:

UPDATE cubmaster SET announce_test = '...new text goes here ...' WHERE xxx = yyy


The xxx and yyy there have to be replace with something that identifies the *ROW* that you want to change.

You don't tell us what columns you have in that table, but I would *guess* that one column is probably either and ID or maybe a CUBMASTERNAME, so you would use a WHERE that included such a field and specify the value of that field in the row you want to change.

If you showed us a "dump" of a few records of that table, we could give you the exact query.

And then, past that, the exact way to *do* the update depends on what server-side system you are using: PHP, ASP, JSP, or whatever. And you didn't tell us that, either.