Chris©: MySql Tabellen bezeichnungen auslesen

Beitrag lesen

Hallo,

SHOW KEYS FROM tabellename

sorry, that's wrong...

show columns from <table>;  passt besser:

probier das mal:

------------------------------------

$con = mysql_connect( ... ... ...);

$sql = "show columns from <table>";

$qry = mysql_query($sql, $con);

if ($qry)
{
  while($rec[]=mysql_fetch_assoc($qry);

echo "<pre>";
  print_r($rec);
  echo "</pre>";
}
else
{
  echo mysql_error();
}

----------------------------------

Viel Erfolg

Chris©