On Thu, 2003-03-20 at 17:09, Alin wrote:
> if you are using mysql try:
>
> $query="show tables";
> $result=mysql_db_query("database-name",$query) or die("Query error");
> whlie(list($table-name)=mysql_fetch_row($result)){
> echo "Columns from $table-name: <br>";
> $query="show columns from $table-name;";
> $result=mysql_db_query("database-name",$query) or die("Query error");
> while($columns[]=mysql_fetch_row($result)){
> echo" $columns[0]<br>";
> }
> }
> Alin Brindusescu
> CareNer Romania
> [EMAIL PROTECTED]
>
>
>
>
> On Wed, 2003-03-26 at 19:37, shaun wrote:
> > Hi,
> >
> > i would like to list all of the tables and field names in my database
> >
> > e.g.
> >
> > table 1
> > field 1
> > field 2
> > field 3
> > table 2
> > field 1
> > field 2
> > field 3
> > table 3
> > field 1
> > field 2
> > field 3
> > etc
> >
> > is there a simple way to do this?
> >
> > thanks for your help
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
