[RESOLVED] Loop Query

[obrienkev]

Hi all,

I want to display the student field from below just once and have course and number displayed while there is data in the database.

How can I do this? Was thinking of nested loop but wasn't working out for me.

$result = mysql_query($query) or die(mysql_error());
$num_results = mysql_num_rows($result);

echo $num_results.'<br />';

echo '<p>Name: '.$row['student'].'</p><br />';

while ($row = mysql_fetch_assoc($result))
{
echo $row['course'].'<br />';
echo $row['number'].'<br /><br />';
}

Cheers,

Kevin.

[thorpe]

what does your query look like?

[obrienkev]

Here's the query:

mysql_select_db('training') or die(mysql_error());

// Perform Query
$query = "select * 
		from details as d
inner
		 join course as c
		 		on d.course = c.course
inner
		 join student as s
		 		on d.ffnumber = s.ffnumber
where
		 d.ffnumber = '$ff'";

$result = mysql_query($query) or die(mysql_error());
$num_results = mysql_num_rows($result);

echo $num_results.'<br />';


echo '<p>Name: '.$row['student'].'</p><br />';

while ($row = mysql_fetch_assoc($result))
{
echo $row['course'].'<br />';
echo $row['student'].'<br /><br />';
}

[thorpe]

well... row is not defined before your loop so this line

echo '<p>Name: '.$row['student'].'</p><br />';

will never work. you might try something like;

$row = mysql_fetch_assoc($result);
echo '<p>Name: '.$row['student'].'</p><br />';
echo $row['course'].'<br />';
echo $row['student'].'<br /><br />';
while ($row = mysql_fetch_assoc($result))
{
    echo $row['course'].'<br />';
    echo $row['student'].'<br /><br />';
}

[obrienkev]

OK. Thanks. Now the loop will not show the first database entry. Why is that? The $num_results displays 3 as value which is all the database entries but the while loop only displays 2 entries.

echo $num_results.'<br />';

$row = mysql_fetch_assoc($result);

echo '<form>';
echo '<p>Student: '.$row['student'].'</p><br />';
echo '<table><tr><td>Course</td><td></td><td>Completed</td></tr>';

while ($row = mysql_fetch_assoc($result))
{
echo '<tr><td>';
echo '<input type="text" name="course" id="course" value="'.$row['course'].'" />';
echo '</td><td></td><td>';
echo '<input type="checkbox" name="completed" id="completed" value="1" />';
echo '</td></tr>';
}

echo '</table>';
echo '</form>';

[leatherback]

 mysql_select_db('training') or die(mysql_error());

// Perform Query
$query = "select *
        from details as d
inner
         join course as c
                 on d.course = c.course
inner
         join student as s
                 on d.ffnumber = s.ffnumber
where
         d.ffnumber = '$ff'";

$result = mysql_query($query) or die(mysql_error());
$num_results = mysql_num_rows($result);

echo $num_results.'<br />';

while ($row = mysql_fetch_assoc($result))
{
if($oldname <> $row['student'])
  {
  echo '<p>Name: '.$row['student'].'</p><br />';
  $oldname = $row['student'];
  }
echo $row['course'].'<br />';
echo $row['student'].'<br /><br />';
}  

Hope it helps

[obrienkev]

Did this and it works. Thanks guys for your help!!

$row = mysql_fetch_assoc($result);

echo '<form action="update.php" name="form" method="post">';
echo '<p>Student: '.$row['student'].'</p>';
echo '<p>FF Number: '.$row['ffnumber'].'</p><br />';
echo '<table><tr><td>Course:</td><td></td><td>Completed:</td></tr>';


do
{
echo '<tr><td>';
echo $row['course'];
echo '</td><td></td><td>';
//echo '<input type="checkbox" name="completed[]" id="completed" value="'.$row['ffnumber'].'" class="box" />';

echo '</td></tr>';
}
while ($row = mysql_fetch_assoc($result));

echo '</table><br />';
echo '<input type="submit" name="submit" value="Update" /><br /><br />';
echo '</form>';