Drop Down List Showing Table Names

[chr158]

Hi there,

In my application, I am wanting to use my login (using SQL DB users permissions) to gain access to my SQL Server and DB. Once a connection is made I want to ask the user to select the table that they wish to view and edit.

I have written no code for this yet, This is just a hit in the park to see if people think it is possible.

Of course once the table is selected from the list, it will then become the session variable and used in the sql for adding, removing and editing data in the chosen table.

All Ideas are much appreciated in advance.

Cheers

[barand]

This will give a list of tables

$q = mysql_query("show tables");
while ($row = mysql_fetch_row($q)) {	
	echo "$row[0]<br>";
}

hth

[chr158]

It doesn't look like MSSQL supports the SHOW TABLES commands.

I have been told to use Meta Data but that sounds complicated.

[barand]

Here's a quote from my MSSQL book

To find out table information, the command would be as follows:

SELECT * FROM INFORMATION_SCHEMA.TABLES

I have no access to MSSQL so can't verify what it gives

[chr158]

Thanks For Your Help, I think I have fixed it with the code below:

$sql = "select * from sysobjects where xtype = 'u' ";

Thank You Very Much.

This Forum Is great