list tables and fields?

[v3nt]

i have been given access to a database but i do not know any of the tables or fields inside the tables.

Is there a simple way i can list this contents?

<?
$host = "localhost";
$user = "kmw";
$pass = "qwerty";
$db = "HGARPS";
?>

[LordShryku]

[man]mysql_list_tables[/man], [man]mysql_list_fields[/man]

[v3nt]

cheers that put me in the right direction....
got this back. not really sure how to pull out just the row names instead of all the details....

Table: pictures
Array ( [Field] => synchDel [Type] => smallint(6) [Null] => [Key] => [Default] => 0 [Extra] => ) Array ( [Field] => synchRec [Type] => datetime [Null] => YES [Key] => MUL [Default] => [Extra] => ) Array ( [Field] => ipcode [Type] => char(9) [Null] => [Key] => MUL [Default] => [Extra] => ) Array ( [Field] => ipicfile [Type] => char(16) [Null] => [Key] => PRI [Default] => [Extra] => ) Array ( [Field] => itype [Type] => char(2) [Null] => [Key] => [Default] => [Extra] => ) Array ( [Field] => ipicname [Type] => char(20) [Null] => [Key] => [Default] => [Extra] => ) Array ( [Field] => iregister [Type] => datetime [Null] => [Key] => MUL [Default] => 0000-00-00 00:00:00 [Extra] => ) Array ( [Field] => iamend [Type] => datetime [Null] => [Key] => MUL [Default] => 0000-00-00 00:00:00 [Extra] => ) Array ( [Field] => ipicsent [Type] => tinyint(1) [Null] => [Key] => [Default] => 0 [Extra] => )

[LordShryku]

Just loop through the array and echo the field value.

foreach($array as $sub) {
   echo $sub['Field'].'<br />';
}

[v3nt]

have done this. but something is a bit wrong. it only seems to be printing one letter for each sub?

http://pod-185.dolphin-server.co.uk/Reapit/hgasite/hg_php/hg_start_b.php

if (!$result) {
echo "DB Error, could not list tables\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}

while ($row = mysql_fetch_row($result)) {
echo "<BR><b>Table: $row[0]</b><BR>";
$resultx = mysql_query("SHOW COLUMNS FROM $row[0]");
if(!$resultx) {
echo 'Could not run query: ' . mysql_error();
exit;
}
if (mysql_num_rows($resultx) > 0) {
while ($rowx = mysql_fetch_assoc($resultx)) {
// print_r($rowx);
foreach($rowx as $sub) {
echo $sub['Field'];
}
}
}