Need tutorial

[Spec]

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

[:Edzy]

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:


www.uploadz.co.uk it.

[Spec]

there ain't a screeny there i dont have a clue why thats there..

Just read the text

[Drompo]

<?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
}
?>

Something like that, Have a Play

[Spec]

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.

[Mr Macro]

So your looking for a script not a tutorial.

[Spec]

Anything will do

[Mr Macro]

<?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
}
?>

Something like that, Have a Play

There you go.

[:Edzy]

There you go.

lolz

[Drompo]

When i post scripts people seem to be oblivious to them