hi.. i am trying to execute and display SQL data on Submit click.. but there seems to be an error with isset($_POST["submit"] because when i delete that part, the data is displayed. please, i really need your help.. this is for my Bachelor thesis.. here is the code block..
<?
$sql = "SELECT s.subj_code, s.subj_title, s.subj_unit
FROM subject s
LEFT JOIN curriculum c ON s.curriculum = c.curr_year
WHERE s.curriculum = '2006-2007'";
$result = mysql_query($sql)
or die (mysql_error());
if (isset($_POST["submit"])){
while ($row = mysql_fetch_assoc($result)) {
echo '<tr>';
echo '<td>' . $row['subj_code'] .'</td>';
echo '<td>' . $row['subj_title'].'</td>';
echo '<td>' . $row['subj_unit'].'</td>';
echo '</tr>';
}
}
?>
thank you so much!!