Davy
put this into a script and run it .......
$dbase = "somedatabase"; // change this to suit !!
$db = mysql_connect("localhost", "root"); // change this also!!
mysql_select_db($dbase,$db);
$result = mysql_list_tables($dbase);
$rowcount = mysql_num_rows($result);
for ($j = 0; $j < $rowcount; $j++){
$tablenam = mysql_tablename($result, $j);
echo "<strong>".$tablenam."</strong> (";
$fieldresult = mysql_list_fields($dbase, $tablenam);
$fieldcount = mysql_num_fields($fieldresult);
echo $fieldcount." fields)<br>\n";
for ($k = 0; $k < $fieldcount; $k++){
$fieldnam = mysql_field_name($fieldresult, $k);
echo " ".$fieldnam." <small>";
$fieldtyp = mysql_field_type($fieldresult, $k);
echo $fieldtyp." (";
$fieldsiz = mysql_field_len($fieldresult, $k);
echo $fieldsiz.") </small><br>\n";
}
echo "<hr>\n";
}
that should tell you everything you need to know about your database and how
to do it.
----- Original Message -----
From: "Davy Obdam" <[EMAIL PROTECTED]>
To: "PHP-WIN" <[EMAIL PROTECTED]>; "PHP" <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 5:24 AM
Subject: [PHP-WIN] Looping through the mysql_field_name function
> Hi ppl,
>
> I have a problem that probably very simple, but i cannot figure it out
> right now....
> I need to get the field names of my database. I have a query like select
> * from books and now i wanna have both the result and the field name. I
> have been trying with mysql_field_name, but not succesfully...
>
> $i = 0;
> for($a=0; $a < sizeof(mysql_field_name($db->sqlResult, $i)); $a++) {
> echo mysql_field_name($db->sqlResult, $i)."<br />";
> $i++;
> }
>
> Can anyone help me please.. Your help is greatly appreciated;-)
>
> Best regards,
>
> Davy Obdam
> mailto:[EMAIL PROTECTED]
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
