mysql field lists

Anon

So how do i list all the fields in my table?
I have added and deleted so many and i have lots count. Please help

lawnmowerman

You could access the MySQL command line interface and use:

mysql> describe MyTable;

This will print each field, the field type, whether or not it can be null, if it is the primary key, any default values, extra field definitions, and the privs your user has to the field.

If you want to do this from PHP, you can get a field list quite easily:

$result = mysql_query( "SELECT * FROM MyTable" );
for( $i = 0; $i < mysql_num_fields( $result ); $i++ )
print mysql_field_name($result, $i) . "<br>";

-Rich

Anon

I have tried like this and had NO luck<?

$db_name = "my_name";
$table_name = "table_name";

$connection = @mysql_connect("db.my.db", "name", "pass")
or die("Couldn't connect.");

$db = mysql_select_db($db_name, $connection)
or die("Couldn't select database.");

$result = mysql_query( "SELECT * FROM table_name" );
for( $i = 0; $i < mysql_num_fields( $result ); $i++ )
print mysql_field_name($result, $i) . "<br>";

<HEAD>
<TITLE>Create a Database Table: Step 3</TITLE>
</HEAD>
<BODY>

<? echo "$result" ?>

Sorted

</BODY>

Please help
Regards
Jules@hungrybear.co.uk

lawnmowerman

In your mysql_query() statement, you are not calling the variable $table_name, but rather are attempting to query a table named 'table_name'.

If you add the '$', this should work.

-Rich