PHP + Javascript

[doltmann]

How would I go about this:

I want a javascript confirm() dialog to pop up whenever a user clicks on delete, and then if confirm() returns true then delete the row from the MySql database... Ive got a basic idea on how to go about this, but I dont really have a lot of time, so I figured id ask someone else how they would go about it.

Also, the command "ORDER BY $colomn $order" dosent exactly Order by!! If anyone knows any better way to sort an array that could be quite a few hundred rows in the future, please let me know... (check out the site and use the sorting arrows youll see what i mean)

Oh, this is where it goes if anyone wants to take a gander...

http://yellow.cei-waco.com/derricko/rate/rate_admin_test.php

[steadyguy]

First off ... ORDER BY column1, column2 will often give you strange results. You may want to just use a single column, or a GROUP BY clause.

As for the dynamically generated JS, this is an extremely shortened version of what I used:

print '<form action="deleter.php" method="post"><input type="submit"  value="Delete" ';
print "onclick=\"if (!confirm('Are you sure you want to completely remove this item from the db?')) {return false;}\" /></form>";

Pop that into a loop, and off you go.

You could also put the JS into a function, then call the function with something like onclick="ensure();". That's probably a better solution, actually ...