first delete then insert

[Anon]

I've this section which is to be updated daily. What i want to do is make a form which when submitted deletes a range of records and insert themselves in those rows. Please help.

[[deleted]]

What exactly do you want to do?

[Anon]

I want to delete old records of that table and insert new one

[[deleted]]

Ya, but, where's the problem?
Don't you know the format of a DELETE query?
Can't you get the data to identify the records that should be deleted?
what's the problem?

[mrobben]

Sounds like you best use an UPDATE query for this...
Just: UPDATE table SET field1 = 'value' WHERE id = 'value'

Good luck, Maarten

[Anon]

obviously you didn't prepart your database for the delete, insert clause... you can do this by first figuring out the name of your database, then type this at the mysql prompt

drop database YOUR_DATABASE_NAME_HERE;

that will ready your database for the drop function which deletes and inserts new records.

good luck!

[[deleted]]

eh? what does a delete/insert have to do with dropping an entire database??