Printable View
On [IMG]file:///C:/DOCUME%7E1/Ryan-/LOCALS%7E1/Temp/moz-screenshot.jpg[/IMG] [IMG]file:///C:/DOCUME%7E1/Ryan-/LOCALS%7E1/Temp/moz-screenshot-1.jpg[/IMG] how to delete several rows on a mysql database using checkboxes, so you check loads of differant rows and it deletes them all.
Ty
lol we cant see files on your pc :rolleyes:Quote:
Originally Posted by Spec
www.uploadz.co.uk it.
there ain't a screeny there i dont have a clue why thats there..
Just read the text :)
Something like that, Have a PlayPHP Code:<?php
$host = "localhost";
$username = "username";
$password = "password";
$database = "database";
$connect = mysql_connect($host, $username, $password);
$select_db = mysql_select_db($database, $connect);
if($_GET["action"] == "delete") {
$id = $_POST["id"];
mysql_query("DELETE FROM `table` WHERE `id` = '$id'") or die (mysql_error());
echo "$id Deleted";
} else {
$query = mysql_query("SELECT * FROM `table`") or die (mysql_error());
while ($view = mysql_fetch_array($query)) {
?>
<input name="checkbox" type="checkbox" value="<?php echo "{$view["id"]}"; ?>" /><?php echo "{$view["text"]}"; ?>
<?php
}
?>
<input type="submit" value="Delete">
<?php
}
?>
Im not really sure thats what im looking for
Basically says theres a page while'ing out a database of users, theres 5 users in the database it looks like this:
Bob
Ryan
Mark
Tom
Dan
Basically i want each name to have a checkbox next to it, and when you click "Delete Checked" button it goes to a page then deletes all the people that were checked from the database.
So your looking for a script not a tutorial.
Anything will do
There you go.Quote:
Originally Posted by Reina
lolz :PQuote:
Originally Posted by Mr Macro
When i post scripts people seem to be oblivious to them
Thats not what i want, hence i was posting again, Mr.SmartAss.
That is what you want seems as it works with what you described, Mr.SmartIdiotQuote:
Originally Posted by Spec
Dont get grumpy.
nobody will help you if you get grumpy.
I think I know what i want, ty.Quote:
Originally Posted by Blob
Quote:
Originally Posted by Spec
Reinas script displays the users with a checkbox them beside and when you press delete it deletes the usersQuote:
Im not really sure thats what im looking for
Basically says theres a page while'ing out a database of users, theres 5 users in the database it looks like this:
Bob
Ryan
Mark
Tom
Dan
Be grateful or leave.
That script Reina posted shows you how to do it.Quote:
Originally Posted by Spec
ditto - that script is what you explained you wanted. if you want something different EXPLAIN IT AGAIN AND BETTER.
Other than that go to another forum.
That has one box on it.. =/
You put the form bit befor the part where it echos out the usernames in the loop.So it echos out the username and the checkbox for each user.
But it doesnt.
What ?
it echos out the entrys in the database yah, but when i tick and click delete it doesnt delete.
You need to edit the code... that code was a sample, you need to edit it for your own needs, or better yet, learn what it does and rewrite it for your needs.
ive tryed
Use an array > loop it, stop the loop from continusly looping.