Array not printing

Anon

I've used the following code to display some info about a users perscription history from a database. The code below works fine but only shows one row of data when there are 17 in the database for one particular user...(this applies to al users) Why may this be?? It only prints the first bit of data in the array!

if (session_is_registered("valid_user")&&($activated == '1'))
{

// Count perscription requests for current user
$sql_select2 = "select * from perscriptions where user_id = '$user_id'";
$result2 = mysql_query ($sql_select2);
$per_count = mysql_num_rows($result2);
$row2 = mysql_fetch_array($result2);

	$user_id_disp = $row2["user_id"];
	$rp_id = $row2["rp_id"];
	$rp_year = substr($row2["rp_date"],0,4);
    $rp_month = substr($row2["rp_date"],4,2);
    $rp_day = substr($row2["rp_date"],6,2);
	$rp_time = $row2["rp_time"];
	$pending = $row2["pending"];

	if($pending=="0")
	{
		$status="No";
	}
	if($pending=="1")
	{
		$status="Yes";
	}

echo "You are logged in as: $valid_user<blockquote></blockquote>";

if($per_count > 0)
{
print "<blockquote>You have $per_count repeat perscriptions stored in our database. Please view these below.</blockquote>";
?>
<table border="0" cellpadding="2" cellspacing="0" width="90%" align="center">
<tr>
<td bgcolor="#98BEDE">No.</td>
<td bgcolor="#98BEDE">Request Date</td>
<td bgcolor="#98BEDE">Pending</td>
<td bgcolor="#98BEDE">View?</td>
<td bgcolor="#98BEDE">Edit?</td>
<td bgcolor="#98BEDE">Delete?</td>
</tr>
<?

  print("<tr>");
  print("<td><font face='Arial, Helvetica, sans-serif' size='2'>$rp_id</font></td>");
  print("<td><font face='Arial, Helvetica, sans-serif' size='2'>$rp_day-$rp_month-$rp_year at $rp_time</font></td>");
  print("<td><font face='Arial, Helvetica, sans-serif' size='2'>$status</a></font></td>");
  print("<td><font face='Arial, Helvetica, sans-serif' size='2'><a href='view.php?rp_id=$rp_id'>View?</a></font></td>");
  print("<td><font face='Arial, Helvetica, sans-serif' size='2'><a href='edit.php?rp_id=$rp_id'>Edit?</a></font></td>");
  print("<td><font face='Arial, Helvetica, sans-serif' size='2'><a href='delete.php?rp_id=$rp_id'>Delete?</a></font></td>");
  print("</tr>");
  print("</table>");

}

if ($per_count == '0')
{
print "You do not have any repeat perscriptions in our database.";
}

}

leatherback

As far as I know, mysql_fetch_array() doesn't give you the full array, but only one row of data. In order to get all data, you'l have to 'loop through the results' and build the dataset that way.

Try:
$TableContent = ""

while $row2 = mysql_fetch_array($result2)
{
$TableContent .= "<td>$row2[userid]</td><td>$row2[rp_date]....Whatever other data you want....";
}

<? echo $TableContent ?>

van__

Well, you only call 1 row of data here...
$per_count = mysql_num_rows($result2);
$row2 = mysql_fetch_array($result2);

And I see no other reference to repeat the process.

so............

for ($i=0;$i<mysql_num_rows($result2);$i++) {
$rows[$i] = mysql_fetch_array($result2);
}

//here's your array
print_r($rows)