|
|
Posted by J.O. Aho on 08/11/06 20:31
mpar612@gmail.com wrote:
> Hi everyone,
>
> I appreciate all of your help with me and the problems I have been
> having. I'm new to PHP and MySQL and I'm having some problems getting
> this script to work. I can't get this to work and I don't understand
> why. I don't get an error or anything, it almost seems like the page
> refreshes. I went to the phpmyadmin and the row is still in the
> database. The $_GET parts work perfectly in another script and the SQL
> statement works when I insert hard values in it. Any thoughts would be
> greatly appreciated. Thanks in advance.
> <form method="POST" action="<?php print $_SERVER['PHP_SELF']; ?>">
> $isbn = $_GET['isbn'];
> $artist_name = $_GET['artist_name'];
> $album_title = $_GET['album_title'];
The form method is POST, then
$_GET['isbn']=$_GET['artist_name']=$_GET['album_title']=NULL
use $_POST['isbn'], $_POST['artist_name'] and $_POST['album_title'].
You can simplify your form tag, action="" is the same as calling itself, less
code and less work for PHP if you use:
<form method="POST" action="">
> $delete_sql = "DELETE FROM lounge WHERE isbn = $isbn AND artist_name =
> \'$artist_name\' AND album_title = \'$album_title\'";
$delete_sql = "DELETE FROM lounge WHERE isbn = $isbn AND artist_name =
'$artist_name' AND album_title = '$album_title'";
Remember that the column isbn has to be INT.
//Aho
Navigation:
[Reply to this message]
|