} if ($_GET['Info1'] == 1) { $sql .= "Info2=NULL, "; } else { $sql .= "Info2='" . $_GET['Info2'] . "', "; } $sql .= " Notes='" . $_GET['Notes'] . "', StartDate='" . join_date($_GET, 'StartDate') . "'"; //if ((isset($_GET['EndDate_year'])) && ($_GET['EndDate_year'] != '')) //{ $sql .= ", EndDate='{$enddate}' WHERE PatientCode='" . $_GET['code'] . "' AND StartDate='" . $_GET['start'] . "'"; //} //else //{ // $sql .= " WHERE PatientCode='".$_GET['code']."' AND StartDate='".$_GET['start']."' AND EndDate='".$_GET['end']."'"; //} $sql = replace2null($sql); // form_data2table($_GET); // echo "<pre>"; // echo $sql; execute_query($sql); // echo mysql_error(); // die; execute_query("UPDATE hbv_antiiikes_treatments SET EndDate='{$enddate}', StartDate='" . join_date($_GET, 'StartDate') . "' WHERE PatientCode='" . $_GET['code'] . "' AND StartDate='" . $_GET['start'] . "'"); // UPDATE StartDate Change in Dosages execute_query("UPDATE hbv_antiiikes_treatments_dosages SET StartDate='" . join_date($_GET, 'StartDate') . "' WHERE PatientCode='" . $_GET['code'] . "' AND StartDate='" . $_GET['start'] . "'"); // UPDATE EndDate Change in Dosages execute_query("UPDATE hbv_antiiikes_treatments_dosages SET EndDate='{$enddate}' WHERE PatientCode='" . $_GET['code'] . "' AND EndDate='" . $_GET['end'] . "'"); perform_post_insert_actions("", "hbv_show_antiiikes_data.php?code=" . $_GET['code'], ""); mysql_close($dbconnection); ?> </BODY></HTML>
$result = execute_query($query3); ?> <div id=data style="display: none" class="img-shadow"> <?php query2table($result); mysql_close($dbconnection); ?> </div> <div class="img-shadow"> <p style="display: block; border: 1px solid #a9a9a9"> This is a test sentence with shadow </p> </div> <p> <?php echo replace2null("Hello, ''"); ?> </p> <script> function show() { if (document.all.data.style.display == "none") { document.all.data.style.display = ""; } else { document.all.data.style.display = "none"; } } </script>