Execute SQL and display data on Submit click

[gabriellevierneza]

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!!

[PHP Monkeh]

I take it the form which is submitting this data:

 

a)  is using the POST method and

b)  has a field named 'submit'

[gabriellevierneza]

yes it does.. but i dont know why isset doesnt work 

[jl5501]

have you tried putting print_r($_POST) in your php, to show what you are getting?

[gabriellevierneza]

have you tried putting print_r($_POST) in your php, to show what you are getting?

 

no i havent.. i havent tried that before either.. where can i put that?

[PHP Monkeh]

Put it anywhere on the page which is handling the form submission, as it will show you what the $_POST array contains (and so you can see if 'submit' is in there).