drag and drop SQL queries in PHP

OneSeventeen

as the subject states I'd like to use a little bit of OOP and be able to drag-and-drop things on a web page to initiate SQL queries.

I've got mySQL and PHP 4 running on a windows box, and I have a database with a list of about 50 items.

I want to be able to have a master list of all the items in the table (just one field printed out, probably the first 20 characters) then be able to drag the title and drop it into one of 5 boxes. If it is dropped into box 1, then it would update the "box1" field to have a 1 instead of a zero. If it were dropped into box 2, then it would update the "box2" field to have a 1 instead of a zero, and so on. If I drug something from box 3 to the trash can (probably a big box, or maybe just if I drug it to white space?) then it would update the "box3" field to have a zero instead of a 1.

how hard would this be? I've done a bit of work similar in visual basic, but that was about 5 years ago.

tbach2

You know, not being a mac user, I just don't think about things like drag-n-drop very much. So I had to try it on the form to write this message. Looks like you can drag and drop between inputs, but its more like copy-and-paste than cut-and-paste.

If you used javascript to detect onchange, you could probably submit the contents of that field to update the database and then redraw the web page to reflect whatever changes you're making. There are also some tricks you can use with javascript, iframes, and httpRequest in order to update the fields without redrawing the web page, but it does get rather involved pretty quick.

I would probably make some buttons to move the data in and out of fields, as in the wsftp gui. That would be a fairly straightforward javascript solution then...