I have a webapp I'm developing where a user can submit items to the website. An admin of the site can then go in and Approve or Delete multiple entries at once. What I'm having a problem with is editing multiple entries at once.

I have no problem getting selected entries out of the table. But I have absolutely no idea how I would go about changing multiple entries in a table in one query.

Any ideas?

Nevermind on that one! If anyone else is having this same problem heres a great place to go to figure it out!

http://www.phpeasystep.com/mysqlview.php?id=10

Yep, SQL doesn't support arrays (I'm not aware of any dialect that does at least?) as it's set based.

You need to use some procedural code to iterate through the array and execute multiple SQL queries - you could always create a user defined function to do this in the database rather than in your scripting language (e.g. PHP), but I'm not sure there is any significant advantage?