Is there an easier way to output results from mysql

[adrianuk29]

I currently output my results for all my databases using the following standard code. I was wondering if there was an easier way to this to cut down on the amount of code used.

//////////////////////////////////////////////////////////////////////////////////
include("conn.inc.php");
mysql_connect($servername,$username,$password);
$query = "SELECT * FROM table_name WHERE id=$id";
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
/////////////////////////////////////////////////////////////////////////////////

$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$first_name=mysql_result($result,$i,"first_name");
$surname=mysql_result($result,$i,"surname");
$tel_number=mysql_resul($result,$i,"tel_number");
$mobile_number=mysql_result($result,$i,"mobile_number"); ?>

echo "$first_name"; ?>

and so on..............

[bastien]

while ($rows = mysql_fetch_array($result)){

   echo "<tr><td>".$rows['first_name']."</td><td>".$rows['last_name']."</td></tr>";

}//end while

or for truly dynamic values

while ($rows = mysql_fetch_array($result)){

   echo "<tr>";

foreach ($rows as $value){
 echo "<td>$value</td>";
   }//next

   echo "</tr>";

}//end while

[PhiSYS]

Yes, it's hard to work with mysql_result for large sets. Better use mysql_fetch_array() the way Bastien shows.
You don't need to worry about mysql_numrows.

include("conn.inc.php");
mysql_connect($servername,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT * FROM table_name WHERE id=" . $id;
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
  echo $row['key'];
}

mysql_close();