Code: Select all
10 10 10 10 10
1 1Code: Select all
$sqlq="SELECT * FROM Members";
$objRS = mysql_query($sqlq);
$num = mysql_numrows($objRS);
?>
<div id="content">
<div id="contentleft">
<h2>Lede Betaal geskiedenis</h2>
<table>
<?
$i=0;
while ($i < $num) {
$email = mysql_result($objRS,"email");
$name = mysql_result($objRS,"Name");
$sname = mysql_result($objRS,"Surname");
$neename = mysql_result($objRS,"Nee");
$city = mysql_result($objRS,"City");
$reference = mysql_result($objRS,"id");
$sqlm = "SELECT * FROM fees WHERE member = '".$reference."'";
$objRSi = mysql_query($sqlm);
$numi = mysql_numrows($objRSi);
echo "<tr><td>".$name." ".$sname." </td><td>".$neename." </td><td>".$email." </td><td>".$city."</td></tr>";
$j=0;
while ($j < $numi) {
$amount = mysql_result($objRSi, "amount");
$date = mysql_result($objRSi, "Date");
echo "<tr><td></td><td></td><td align=right>".$date." </td><td align=right> ".$amount."</td></tr>";
$j++;
}
$i++;
}
?>
</table></div>on line two I was expecting a date and a number. What have I done wrong? Please help.