Printing out a table

[mtgriffiths]

Hi All,

 

I am tryin to print out a table depending on the results of my query.

 

All the information echos out correctly but i cant get the layout correct what so ever.

 

The code im using is:

 

<?php
$Search = mysql_query("SELECT DISTINCT students.Enrollment, students.First_Name, students.Last_Name, student_attendance.Student_ID, student_attendance.Date FROM students INNER JOIN student_attendance ON students.Student_ID = student_attendance.Student_ID WHERE student_attendance.Date = '$Date'")or die(mysql_error());
?>

<?php
echo "<table border='0'>";
echo "<tr align='center'>";
echo "<td width='20%'><font color='#FFFFFF' face='Calibri'>";
echo "Enrollment No";
echo "</td><td width='20%'><font color='#FFFFFF' face='Calibri'>";
echo "First Name";
echo "</td><td width='20%'><font color='#FFFFFF' face='Calibri'>";
echo "Last Name";
echo "</td><td width='20%'><font color='#FFFFFF' face='Calibri'>";
echo "Date";
echo "</td></tr>";

while($myrow = mysql_fetch_array($Search))
{
echo "<tr align='center'>";
echo "<td><font color ='White' face = 'calibri'>";	echo $myrow['Enrollment'];
echo "</td><td><font color ='White' face = 'calibri'>";	echo $myrow['First_Name'];
echo "</td><td><font color ='White' face = 'calibri'>";	echo $myrow['Last_Name'];
echo "</td><td><font color ='White' face = 'calibri'>";	echo $myrow['Date'];
echo "</td></tr>";
echo "</table>";
}
?>

 

Can any one help me?

 

Thanks

 

Matthew

[cooldude832]

and the correct layout involves dancing clowns feeding penguins on the moon?

[mtgriffiths]

The layout i mean is that all the data falls into the correct field in the table

[AndyB]

move the closing table tag outside the while loop.

[Caesar]

and the correct layout involves dancing clowns feeding penguins on the moon?

 

Probably one of the top 5 best posts I've seen on these boards since I signed up :-P