how to insert data into two table using in php mysql

11y1.1kPHP

how to insert data into two table using one single query in php mysql? my table name are popup_question and popup_answer . popup_answer table has multiple row and i went to insert multiple row on the table popup_answer and popup_question . popup_question does not have multiple row. please help me. my code is bellow

thank's

include('config.php');

session_start();

$msg="";

if(isset($_POST['h_action']))

{

$val_h_action=$_POST['h_action'];

}

if(isset($_POST['h_id']))

{

$val_h_id=$_POST['h_id'];

}

if($val_h_action=="delete")

{

mysql_query("DELETE FROM popup_question WHERE Id='$val_h_id'");

mysql_query("DELETE FROM popup_answar WHERE Question_id='$val_h_id'");

$msg=md5("1");

header("location:Add_pop_up_question.php?msg=$msg");

}

/* $option_b_campaign="";

$result2=mysql_query("select DISTINCT campaign_id from popup_question");

while($qdata=mysql_fetch_array($result2))

{

$campaign_id=$qdata['campaign_id'];

//$asset_name=$qdata['asset_type'];

$option_b_campaign .= "";

} */

//$sql=mysql_query("select DISTINCT campaign_id from popup_question");

//while($row=mysql_fetch_array($sql))

//{

//echo "

how to insert data into two table using in php mysql

Qualify Question Entry

Existing Pop Up Questions

1 Reply