delete

[sub01]

hey,

i have this function delete_rec which supposed to be called by a hypertext link and automatically delete the row..I have a delete link for each row.
I tried but it's not working.
The link is in another function. I don't know if that matter.
When I click on the delete link the page refresh and the query is only missing the id...function and table passed...so i don't know.
this is it:

function delete_rec($table,$id){
        $query = "DELETE FROM $table WHERE id = '$id'";
        echo "Record no. $id has been deleted!";
        return $query;
}

this is the a href link:

\t\t<td><a href=\"week6_a.php?function=delete_rec&table=$table&id=$id\">delete</a></td>\n";

thanks,s

[hkucsis]

in your link, why you have \" ?

&id=$id\">

[sub01]

I apologize but cutting and copying I left something out:

print "<td><a href=\"week6_a.php?function=delete_rec&table=$table&id=$id\">delete</a></td>";

this is my query when I click on delete(I manage to pass everything, but it doesn't delete) the table disappears.

week6_a.php?function=delete_rec&table=week_4&id=1

thanks,s

[hkucsis]

Can you post more code? You query should work.

[sub01]

hey,
(right now I also get the message that I deleted a row, but it doesn't really deletes anything!!!!

this is the function that draws the table in the first place with the link:

function table_dump($table,$id){
        $query = "DESCRIBE $table";
        $result = mysql_query($query) or print mysql_error();

    print "<DIV ALIGN=\"CENTER\">";
    print "<table border=1>\n";
    print "<td><b>update</td>\n";
    print "<td><b>delete</td>\n";  

    while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
                 print "<td><b>$row[0]</b></td>\n";
    }

    $query = "SELECT * FROM $table";
    $result = mysql_query($query) or print mysql_error();

    while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    $id = $row["0"];

    print "\t<tr>\n";
         print "\t\t<td><a href=\"\">update</a></td>\n";
         print "\t\t<td><a
href=\"{$_SERVER['PHP_SELF']}"."?delete=3&table=$table&id=$id\">delete</a></td>\n";
                 foreach ($row as $key){
                 print "\t\t<td>$key</td>\n";
        }
        print "\t</tr>\n";
        }
    print "</table>\n";
    print "</DIV>";
}

this is the function which deletes from that table:

function delete_rec($table,$id){
        $query = "DELETE FROM $table WHERE id = '$id'";
        echo "Record no. $id has been deleted!";
        return $query;

}

this is how I call it from another file(the main one):

if(isset($delete)){
        delete_rec($table,$id);
        }

thanks,s

[hkucsis]

Hi,

Your function delete_rec($table,$id) does nothing.....There should be sth like

mysql_query($query) ;

inside this function.