How can i delete database value using an html page in php?

[phil4]

Ok, that leads me to think you might be using a different DB user account than what you did by hand. Incidentally, a good way to work with DB's, is never to delete. Instead to have an isActive column, which is set to 0 in place of a delete, however your whole app then needs to only list items where IsActive=1, so more changes.

Also, you need to be very very sure, that woat you output, is what you've written and tried.

So in your code where you did this:
$id=$_GET['id'];
$query1=mysql_query("delete from news where id='$id'");

do this:

$id=$_GET['id'];
echo "delete from news where id='". mysql_real_escape_string($id) . "'";

and then run the page, and try by hand executing the code it writes out.

I genuinely don't think you're doing this, as your code above doesn't seem to use concat correctly. surely it should be:
"delete from news where id='".$id."'" ???

But even then, as we've said you really really really really really really really!!!!!! MUST use SQL Injection protection. So as has been said earlier you MUST do this:

. mysql_real_escape_string($id) .

[TheAnimus]

In the nicest possible way (which isn't that nice I'm afraid) no, I will not help you.

Did you see the link Fin posted. Not sure exactly what this training company is about, but they don't appear to be remotely useful.

Also anyone learning PHP is a bit dim, anyone paying to learn it really hasn't done any research. Now excuse me whilst I do something with UTF-8.

[devimohan1988]

when i give the code:echo "delete from news where id='". mysql_real_escape_string($id) . "'";
on executiong it is displaying the id.bt still the value remains in the database.delete query is not working.

[phil4]

And when you ran the code that was echo'd by hand against the database, did it delete the value?

Did you investigate

you might be using a different DB user account

And finally, I mentioned not deleting, have you considered that approach?

You're getting the benefit here of clever people with many decades of development experience between them, it would be nice to think you'd read what they put, gone away, and carefully considered and tried what they were suggesting.

[devimohan1988]

the value still remaining in database.what to do next?

[phil4]

Sorry, but you're now beyond the help I can give. You clearly have not read or perhaps not understood what I've put above. As such I can no longer assist.

[devimohan1988]

can u please rewrite my delete.php page?

[phil4]

In a word - No.

[devimohan1988]

k.i dnt.