Weird results from database

[guymclaren]

$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++;
}

?>

 

Gives me this result

 

ede Betaal geskiedenis
10 10 	10 	10 	10
	1 	1

 

I was expecting text, where have I gone wrong?

[DEVILofDARKNESS]

I think it should be something like this:

 

$sqlq="SELECT * FROM Members";
$objRS = mysql_query($sqlq);
$num = mysql_numrows($objRS);
$row = mysql_fetch_row($objRS);
list(
?>

<div id="content">
<div id="contentleft">
<h2>Lede Betaal geskiedenis</h2>
<table>

<?

$i=0;
while ($i < $num) {

$email = $row['email'];
$name = $row['Name'];
$sname = $row['Surname'];
$neename = $row['nee'];
$city = $row['city'];
$reference = $row['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++;
}

?>