newbie stuck again
| From: | PAUL FERRIE | Date: | Sun, 16 Nov 2003 15:17:19 +0000 |
| Subject: | newbie stuck again | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-169833@lists.php.net to get a copy of this message | ||
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.
1. 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
2. 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
http://thor.ancilenetworks.co.uk/~pferrie/vinrev/adm/myadmin.html