Arrays, while loops and tables !

dinkeshpatel

Hi, I am trying to get the following piece of code to work. The data from the table academic belonging to a user of a particular user_id is supposed to be stored into the array $qual and as each user can have more than 1 record, the data is supposed to be feed into tables. However the page just comes up blank. This is only a snippet of the code, I have connect to my database earlier in the script.

I would be gratefull if anyone could tell me where I am going wrong !

<h3>Qualifications</h3>

  <?php

  $sql = \"SELECT * from academic WHERE user_id = $user_id\";
  $qual = mysql_query($sql); 

  while ($qaul = mysql_fetch_array($qual)) {

  ?>

  </td>
</tr>
<tr> 
  <td width=\"19%\" height=\"58\">
  <?php echo $clevel [\'clevel\']; ?></td>
  <?php echo $grade [\'grade\']; ?></td>
  <?php } ?>

dinkeshpatel

I would be gratefull if anyone could tell me where I am going wrong !

  <?php

  $sql = \"SELECT * from academic WHERE user_id = $user_id\";
  $qual = mysql_query($sql); 

  while ($qaul = mysql_fetch_array($qual)) {

  ?>

  </td
</tr
<tr 
  <td width=\"19%\" height=\"58\"
  <?php echo $clevel [\'clevel\']; ?></td
  <?php echo $grade [\'grade\']; ?></td
  <?php } ?>

Sorry ! The previous post did not show the HTML, there i have removed part of the tag brackets!

Anon

Your not assigning the columns in the table to those variables your echoing.

Something like this: (change the front variable on the while loop too)

while ($output = mysql_fetch_array($qual)) {
$clevel = $output["clevel"];
$grade = $output["grade"];
( The areas in the brackets are the name of the columns in the table. The first variable is what will hold its value. Just continue as normal from there, and remember to close out your while loop )