I have two tables
tbla_codes
table2
from table1 i need to pickup s_no field based on code. Code which i receive from another screen and using
code number as HTTP_GET_VARS to get the value of s_no
$code_txt=$HTTP_GET_VARS["code"];
query is as follows
$sql_g_code="select s_no from tbla_codes where g_code='$code_txt'"; // using this query three s_no's data
will come they are 1493,1494 and 1495 Records data
$recset_g_code=$conn->Execute($sql_g_code);
while(!recset_g_code->EOF) // outer while loop
{
$lv_sno=$recset_g_code->fields[0];
$mysql_g_det="select s_no,f_id,m_date,m_s_date,m_c1,m_c2,m_c3,m_g_att from table2 where s_no='$lv_sno'";
$recset_g_det=$conn->Execute($mysql_g_det);
while(!$recset_g_det->EOF) // inner while loop
{
$lv_f_id=$recset_g_det->fields[1];
$lv_m_date = $recset_g_det->fields[3];
$lv_m_s_date = $recset_g_det->fields[4];
// from here printing started
echo $lv_f_id; // 1
echo $lv_m_date; // 2
echo $lv_m_s_date; // 3
$recset_g_det->MoveNext(); // inside while loop closing($recset_g_det loop)
}
$recset_g_code->MoveNext(); // outer while loop closing
}
in this above code 1, 2, 3 are displaying complete data ( 1493,1494 and 1495 ) but i want to display only
1493 data when i clicked one record
1494 data when i clicked on second record
1494 data when i clicked on third record
only one s_no record at a time
