need some help please :(

-webdreamer

Here's what i have done. i have downloaded a very simple database manager from www.hotscripts.com. It allows me to edit, delete and add new information to the database. i have a couple of problems.

form field dont fill with all the data senback from the db to be edited, as fars as i am aware all fields except 'review' are long enough
In my common.php file for connecting to the db i have

<?

$database=mysql_connect ("localhost", "blah", "****") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("***_vinrev"); 

$tablename="albums";
?>

I have 2 tables in my database and would like to use a "drop down menu" to select the table we wish to view and edit. so taken $tablename out of the common.php file and having it sset within the main navigation. i am pretty sure i can set the drop down menu option but what is/would be the $query for returning how many and display table names?

Cheers
Paul
admin link

olaf

use
http://www.phpmyadmin.net/

this script (I think its more than a script) is ready to work

-webdreamer

I dont think understand what i mean.

Website admin area.

i have been using phpmyadmin for the past 2 years to setup and maintain my own db's for www.innovativedesigns.org.uk

Flash+php based site. A job i got this week has required me to build a website with html +php (total newbie to this area)
In flash i would have it done and dusted already.

Cheers
Paul

olaf

Paul, maybe you have to read your own post:

Here's what i have done. i have downloaded a very simple database manager from www.hotscripts.com. It allows me to edit, delete and add new information to the database. i have a couple of problems.

-webdreamer

ok maybe i could have better worded my question :o

Sharif

Okay I think this is what you are trying to do:

Get all the tables in the database and make a drop down menu that holds the tables and some value.

IF SO, here is how you can achieve it.

$db = 'database'; //The name fo the datbase to get tables from
$tables = mysql_list_tables($db); //The variable that holds the list of tables
$results = mysql_fetch_array($tables); //Get the results

//Create a drop down menu
echo '<select>';

//Using while(), loop the result 
while ($row = mysql_fetch_row($result))
{

 echo '<option value="' . $row[0] . '">' . $row[0] . '</option>';
}
//End drop down html code
echo '</select>';

Hope it helps (and works).