Ik ben bezig met een pagina waarop alle ledengegevens staan van een Virtual Airlines. Ik wil deze gegevens mooi weergeven in een tabel. Er staan nu 3 test leden in de database en het script weergeeft ook mooi 3 tabellen, maar hij laat de gegevens niet zien. (nu alleen nog aan het begin van de tabel: $rij->pilootnummer) Hij laat dat gewoon als tekst zien, ik heb al vanalles geprobeerd maar het lukt me niet om het goed te doen. (note: ben pas begonnen met php ;D)
Kunnen jullie mij helpen?
<?php
include ("data.inc");
$global_dbh = mysql_connect($hostname, $username, $password);
mysql_select_db($db, $global_dbh);
$sql = "SELECT * FROM airbelgium";
$res = mysql_query($sql);
while ($rij = mysql_fetch_object($res))
{ echo'<table border="0" width="100%">
<tr>
<td colspan="4" bgcolor="#C0C0C0">
<p align="center">
<font face="Century Gothic" size="2">Member Pilot
ID: ABB $rij->pilootnummer</font></td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Pilot ID</font></td>
<td width="25%" bgcolor="#F8F8F8">
<font face="Century Gothic" size="2">ABB</font></td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Flight
Simulator</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Name</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">IVAO Member</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Sex</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">IVAO</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Date of Birth</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">VATSIM</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Country</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Globalsim</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">City</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">FPI</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Email</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="50%" bgcolor="#F8F8F8" colspan="2"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">MSN</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">ABB Admin</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">ICQ</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">ABB Admin ID</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="100%" bgcolor="#F8F8F8" colspan="4"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Flown Hours</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Previous VA
Name</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Rules Acception</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Previous VA
Pilot ID</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">User Comments</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Previous VA
Flown Hours</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#EFEFEF"> </td>
<td width="25%" bgcolor="#F8F8F8"> </td>
<td width="25%" bgcolor="#EFEFEF">
<font face="Century Gothic" size="2">Previous VA
Website</font></td>
<td width="25%" bgcolor="#F8F8F8"> </td>
</tr>
<tr>
<td width="100%" bgcolor="#EFEFEF" colspan="4"> </td>
</tr>
<tr>
<td width="100%" bgcolor="#FFFFFF" colspan="4"> </td>
</tr>
<tr>
<td width="100%" bgcolor="#FFFFFF" colspan="4"> </td>
</tr>
<tr>
<td width="100%" bgcolor="#FFFFFF" colspan="4"> </td>
</tr>
</table>';}
?>
