print out all records

[Anon]

hey, i want to make a big list from all the entries in a mysql table with 6 columns. with one entry on each line (with data from all 6 columns in that line). any help is appreciated. thanks !!

example:

item quanity price ect..
apples 1 2 3..
oranges 2 3 4...

[Anon]

Here you have some code :
make sure you replace the fields with your own

$query_string = "select * from <your table> order by <column>";
$result = mysql_query($query_string, $verbinding);
$column_count = mysql_num_fields($result);
print("<h3 ALIGN=\"center\">Title</h3>");
print("<TABLE BORDER=1 Widht=100%>\n");
$counter=1;
while ($row = mysql_fetch_object($result))
{
$first=ucfirst($row-><your column_name>);
$second=strtoupper($row-><your second column);
etc till 6

   print("<TR ALIGN=LEFT VALIGN=TOP>");
   /*for ($column_num = 0;
        $column_num < $column_count;
		$column_num++) */
	      print("<TD width=10%>$counter</TD>\n");
		  print("<TD width=40%>$first</TD>\n");
		  print("<TD width=40%>$second</TD>\n");
		  print("<TD width=10%>$third</TD>\n");
		  print("</TR>\n")

etc etc till 6;
$counter++;
}
print("</table>");