[Resolved] no remote access - list columns in MySQL database?

happyme

Hi there,

Due to my rubbish ISP, I cannot have remote access to MySQL on the server. So the only way I can access anything in the database s by writing PHP.

I have lost my notes on the database and can't remember how many columns there are in a particular table or what they are all called. Is there a way I can find this out using PHP? I know the name of the database and the table and my username and password etc.

TIA

Julia

Bijan

Hi Julia, yes, there are several ways!

$link = mysql_connect("$link", "username", "password");
mysql_select_db("yourDBName") or die("Error " . mysql_errno() . " : " . mysql_error()");

$tableName = "myTable";  # Your table name goes here
$query = "select * from $tableName";
$res = @mysql_query( $query);
$numFields = mysql_num_fields( $res);
for ($i=0; $i < $numFields; $i++)
{
	print "<b>Name = </b><i>" . mysql_field_name( $res, $i) . "</i><br>";
	print "<b>Length = </b><i>" . mysql_field_len( $res, $i) . "</i><br>";
	print "<b>Type = </b><i>" . mysql_field_type( $res, $i) . "</i><br>";
	print "<b>Flags = </b><i>" . mysql_field_Flags( $res, $i) . "</i><br>";
	print "<hr><br>";
}

Hope that it helped.

PS:Take care of your notes! 😃

happyme

thank you

I've printed out the result and put it somewhere sensible this time!

cheers

Julia

Elizabeth

You can also use phpmyadmin to administer your database through your web browser-

http://www.phpwizard.net/projects/phpMyAdmin/

Good Luck!

-Elizabeth