Hi i am trying to display on the web browser to allow user to see information before the latest data is been updated. Hence, it will show:
(1)previous existing data,
(2)latest data and
(3)data which is not found on the latest data list.
To make things clear to solve the problem, (1) is already stored in the database. (2) & (3) data is an extra information which will be use to update (1). Any up-to-date information will be overwrite (1) using PHP UPDATE feature.
I did manage to display all 3 information BUT for (3) i
/////////////////////
///
/// LATEST DATA
///
/////////////////////
while ($row_export = mysql_fetch_array($result_export, MYSQL_ASSOC))
{
$HW_dev_num = $row_export['HW_dev_num'];
$platformexport = $row_export['platform'];
$HW_design = $row_export['HW_design'];
$rel_site = $row_export['rel_site'];
/////////////////////////////////
///
/// DATABASE ON EXISTING TABLE
///
/////////////////////////////////
$sql_test = "SELECT *
FROM wsdevice ";
if (trim($pib_bracket_num) !='' and trim($HW_design) !='' )
{
$sql_test .=" WHERE ((wsdevice_pibid like '%$pib_bracket_num%') and
(device_designid = '$HW_design')) ";
$results = mysql_query($sql_test)
or die ("NO SEARCH TERMS");
//echo $results ;
while ($row = mysql_fetch_array($results, MYSQL_ASSOC))
{
/////////////////////////////////
///
/// DISPLAY EXISTING DATA IN
/// TABLE FORM
/////////////////////////////////
/////////////////////////////////
///
/// DISPLAY UPDATE ON LATEST DATA
/// IN TABLE FORM
/////////////////////////////////
}
} else
{
echo $HW_dev_num;
/////////////////////////////////
///
/// DISPLAY LATEST DATA NOT UPDATED
///
/////////////////////////////////
}
}
when i did "echo $HW_dev_num" after the else, i did not get any information which i tried to retrieve from the row at the very beginning for "$HW_dev_num = $row_export; "
should "$HW_dev_num" can pass down after the else statement??