|
|
Posted by Webwasp on 10/11/01 11:55
You need to start paying people here buddy. Or just give up on PHP SQL!!!
<mpar612@gmail.com> wrote in message
news:1155327725.985414.159590@74g2000cwt.googlegroups.com...
> 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']; ?>">
> <table>
>
> <tr><td colspan="2" align="center">Yes <?php
> input_radiocheck('radio','yes_no', $defaults, 'yes'); ?> No <?php
> input_radiocheck('radio','yes_no', $defaults, 'no'); ?>
> </td></tr>
>
> <tr><td colspan="2" align="center"><?php input_submit('save','Add'); ?>
> </td></tr>
>
> </table>
> <input type="hidden" name="_submit_check" value="1"/>
> </form>
>
> <?php
>
> function process_form() {
>
> // Access the global variable $db inside this function
> global $db;
>
> $isbn = $_GET['isbn'];
> $artist_name = $_GET['artist_name'];
> $album_title = $_GET['album_title'];
>
> if ($_POST['yes_no'] == 'yes') {
>
> $delete_sql = "DELETE FROM lounge WHERE isbn = $isbn AND artist_name =
> \'$artist_name\' AND album_title = \'$album_title\'";
> // Delete the record
> $db->query($delete_sql);
> print "The record was deleted";
> } else {
> print "The record was not deleted";
> }
> }
>
> ?>
>
Navigation:
[Reply to this message]
|