John Davidson

Message:

Format of my tables

$sql = "CREATE TABLE tbl_topic (

topic_ID INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 

topic_detail VARCHAR(1000) NOT NULL,

user_name VARCHAR(50) NOT NULL,

user_ID INT(11)

)";





$sql = "CREATE TABLE tbl_answer (

answer_ID INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 

topic_ID INT(11),

answer_text VARCHAR(1000) NOT NULL,

user_name VARCHAR(50) NOT NULL,

user_ID INT(11)

)";

I'm trying to delete two rows of data where the topic_ID match from two separate tables. My Forum page has a form that posts my topic_ID through.

<td>

    <form method="post" action="delete_topic.php">

        <input type="hidden" name="topicID" value="<?php echo $topic["topic_ID"];?>"/>

        <input type="submit" name = "submit" value = "Remove"/>

    </form>

</td>

I want this information to then go to another file "delete_topic.php" which will run an SQL query to delete the row from both table tbl_answer and tbl_topic.

$top=$_POST["topicID"];

$sql = "DELETE FROM tbl_topic WHERE topic_ID= $top";

I'm unsure how to delete tbl_answer as well as tbl_topic. Any suggestions on how this is done. I have seen methods mainly using JOINS but I'm having a hard time applying it to my situation. I have not used a foreign key either if this would be another method of deleting both data at the same time.

---

My Answer:
"DELETE FROM table1, table2 WHERE table1.id = table2.id AND table1.id = 'value';"