List all table fields

[jd57]

Hi

I'm looking for a script to list all fields in mysql database table, can someone show me a typical code or a link where I can get such info.
Regards JD

[bpat1434]

<?php
$conn = mysql_connect('localhost', 'username', 'password') or die('MySQL Error: '.mysql_error());
mysql_select_db('database', $conn);

$k = 0;

$query = "SELECT * FROM `tablename`";
$result = mysql_query($query);
while($row = mysql_query($result))
{
  echo 'Row '.$k.': ';
  $fields = count($row);
  for($i=0; $i<$fields; $i++)
  {
    echo $row[$i].' || ';
  }
}

Something like that......
EDIT
Fixed code typo... (Thanks Houdini)

[jd57]

Hi
I get a blank page.

<?php 
$conn = mysql_connect('localhost', 'xxxx_xx', 'xxxx') or die('MySQL Error: '.mysql_error()); 
mysql_select_db('xxxx_xx', $conn); 

$k = 0; 

$query = "SELECT * FROM `xxxxx`"; 
$result = mysql_query($query); 
while($row = mysql_query($row)) 
{ 
  echo 'Row '.$k.': '; 
  $fields = count($row); 
  for($i=0; $i<$fields; $i++) 
  { 
    echo $row[$i].' || '; 
  } 
} 
?> 

[Houdini]

Run this

while($row = mysql_query($result))

That will produce output.

[bpat1434]

Woops.... thanks for catchin that Houdini.... little code flub on my part...