[Resolved] displaying data in array returned from database

[revez2002]

Hello all,

I am curious as to how to go about displaying the "maximum" variable in the array below only once, while the "username" data continues to display beyond the first row.

for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result2);
echo "<tr><td width=600 align=left>";
echo "<p class=searchReturn2>";
echo htmlspecialchars(stripslashes($row["username"]));
echo "</p></td></tr>";
echo "<tr><td width=600 align=left>";
echo "<p class=searchReturn2>";
echo htmlspecialchars(stripslashes($row["maximum"]));
echo "</p></td></tr>";
}

Cheers,
Revez

[AQHost]

Hi,

Is this what you're looking for?

for ($i=0; $i <$num_results; $i++) 
{ 
   $row = mysql_fetch_array($result2); 
   echo "<tr><td width=600 align=left>"; 
   echo "<p class=searchReturn2>"; 
   echo htmlspecialchars(stripslashes($row["username"])); 
   echo "</p></td></tr>"; 
   if($i == "0")
   {
      echo "<tr><td width=600 align=left>"; 
      echo "<p class=searchReturn2>"; 
      echo htmlspecialchars(stripslashes($row["maximum"])); 
      echo "</p></td></tr>";
   }
}

"maximum" will only be displayed for the first returned record, after that it will be "username" only.

Best wishes,
Simon.

[J_ystick_FI]

try this trick and dispaly only the first row value:

for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result2);
echo "<tr><td width=600 align=left>";
echo "<p class=searchReturn2>";
echo htmlspecialchars(stripslashes($row["username"]));
echo "</p></td></tr>";
echo "<tr><td width=600 align=left>";
echo "<p class=searchReturn2>";
if($i == 0)
{
echo htmlspecialchars(stripslashes($row["maximum"]));
}
else
{
echo " ";
}
echo "</p></td></tr>";
}

it shuold go for you
😃 J@ystick_FI😃

[revez2002]

Thanks for the suggestions! They enabled me to do exactly what I was trying to achieve.

Cheers,

revez2002