Hey Guys. I've got a prob with a little project. I'm making a small management system (insert, view, modify & delete). So far all has gone to plan and it's looking ok. Now, the problem I'm having at the moment is I'm trying to make the deletion side of it. It's ok if I only have one entry, but how would I go about multiple entries?

I'm using forms to drive the system. The person clicks the checkbox and then clicks the delete button. Then I want it to delete the selected records.

I've been on it for about 5 hours (including modify).

Please help me if you can.

- Wenslock

Are you deleting entries from a table or entries from multiple tables?

Ibbo

You do it just like a SELECT query, but use DELETE instead. Lets say you have a table that stores letters, and a field called 'bseen', that is a tinyint, and is set to 0 if the letter has not been seen, or a positive number if the letter has been seen. To delete all letters that have been seen, we just do;

mysql_query("DELETE FROM mail_table WHERE bseen>0", $db);

Just like a SELECT, but if we want to delete the whole field, we leave out the asterisk (*). To explain further; if I wanted to SELECT all the letters that have been seen, I would just do;

mysql_query("SELECT * FROM mail_table WHERE bseen>0",$db);

Thanks webWoRRks. I'll give it a go tomorrow.

ibbo - single table. I've decided that the user has to select the table before deleting the entries.

I'm trying to make it as user friendly as possible for them. To be honest, it would be easier (for me anyway) to use PHP MyAdmin, but they want it this way...

Actually, I will make it so that they have to confirm their deletion too.

Thanks again.

OK, I'm getting fed up of this now. I feel like I'm 180 or something

<code>
if ($delete == yes)
{
if ($confirm == yes)
{
$local = localhost;
$usern = userm;
$passw = passw;
$dbname = db;

mysql_connect($local,$usern,$passw);
mysql_query="DELETE FROM $table WHERE id>$id",$dbname;


mysql_close();
}
}
</code>

That's the bit I'm having trouble with. I'm going on holiday at the end of the week, so I'm trying to get this pain in the *** thing out of the way before I do. Any ideas guys?

<- Me gone mad

Well for one it's not mysql_query="";

It's

PHP Code:

mysql_query("DELETE FROM $table WHERE id>$id"); 


However, if register_globals is set to on, I could delete everything in the database by typing in the URL yourscript.php?table=thetable&id=0

As long as I guess the table name right, it'd delete everything from it. Find other ways of putting in variables to your queries.

ermau - Thanks. I'll see what I can do with

Don't worry about the security. This is only a snippet of the PHP that's used. There's a username, password, etc. I've tried to be really careful with this one. ^_-

Thanks again.

Wenslock

Finally got it working! Thanks guys for your help.

doomo arigato gozaimasu!
(Thank you very much)