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: ";
> $query="show columns from $table-
use mysql_list_tables ?
>= Original Message From "shaun" <[EMAIL PROTECTED]> =
>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
As noted earlier, in the manual
and please don't cross post.
Miles
At 05:37 PM 3/26/2003 +, 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
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://ww
4 matches
Mail list logo