best way to list everything in a table?

[android6011]

is this ok or is there a better way?

 

$query = "SELECT * FROM stuff ORDER BY 'id'";

$result=mysql_query($query);

$i=0;

$num=mysql_numrows($result);

 

while ($i < $num) {

 

 

$info=mysql_result($result,$i,"theinfo");

 

print "$info";

$i++;

}

[The Bat]

If I understand what you're talking about (fetching records from a table), then I think this is what you want...

 

$query = mysql_query("SELECT * FROM stuff ORDER BY 'id'");

while ($row = mysql_fetch_array($query)) {
  echo $row['column_name'];
  echo $row['different_column_name'];
  # etc...
}

 

Much easier

[android6011]

thank you i appreciate it

[soycharliente]

Make sure you check to see that your MySQL resource has rows in it before you start looping through them.

<?php
$sql = "SELECT * FROM `table`";
$result = mysql_query($sql) OR DIE (mysql_error());
if (mysql_num_rows($result)) // RIGHT HERE!
{
while ($row = mysql_fetch_assoc($result))
{
	// do stuff
}
}
?>