Re: [PHP] newbie stuck again

From: Derek Ford (lateralus_at_nutextonline.com)
Date: 11/16/03 

Date: Sun, 16 Nov 2003 10:28:15 -0600
To: PAUL FERRIE <info@innovativedesigns.org.uk>,  "[php]" <php-general@lists.php.net>

PAUL FERRIE wrote:

>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
>
>
>
your probably looking for something like 'show tables'.

Relevant Pages

  • Re: One more (maybe stupid) database question
    ... AlwaysShowEditor just automatically enables Edit when a record is selected, ... This makes sense for a database with a single file, ... database that you can run queries against. ... of TechIDs, for instance, but I write updates directly to the tables. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Can a lone computer have Access db problems?
    ... His current problem was that he was not able to edit the data ... nor was his permissions changed). ... certain computers to misbehave). ... When you say he is "authorized", that sounds as if the database is ...
    (comp.databases.ms-access)
  • Re: Many Instances
    ... Data in the database is from importing many excel files. ... It can be tough to make sure that 2 people aren't editing the same record. ... someone attempts to edit a record ... ... power button, or loses network connectivity, etc) since this will leave the flag field set to True even if no one is ...
    (microsoft.public.access.modulesdaovba)
  • Re: does textpattern have a forum for discussing issues?
    ... I moved the files and the database but I'm still ... getting an error message: ... I rebuilt a site that once ran on Textpattern. ... To find a page (in order to edit it) they had to negotiate a series ...
    (comp.lang.php)
  • Re: Putting database on a network drive
    ... I have built my 1st database and it is ready to go on a shared network ... You can apply user level security to an mdb file. ... the database but only let myself edit the database. ... search through the form that opens but then have a password for me or ...
    (comp.databases.ms-access)