join three table in mysql using php

11y1kPHP

hi i am trying to fetching data from the database when i am selecting the campaign name from dropdown list item without submit button click in php mysql.

and the data is fetch from the three table . my table name is popup_question, popup_answar, and answar_mode,

the table field in popup_question are Id,question_text, mod_id, set_id, question_id, and campaign_id

and the table popup_answar are contain id, question_id, answar_text

and table answar_mode contain id, mode field. i am trying to select campaign_id and get the result from database . the result table contain field

and data r bellow

answar_text, question_text, answar_mode. please help me i am new in this field.

my code is bellow----

include('config.php');

/* $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 "

join three table in mysql using php

Qualify Question Entry

Existing Pop Up Questions

1 Reply