* Gordon Stewart > (I'll assume you can do EVERYTHING in PHP as you can in dos... ??)
yes, almost... when you say 'dos', I assume you mean the mysql client console. There are a couple of things you can do in the client console that can not be done with the client api... like using \c to cancel a partially entered query, or \G to get the result vertically...: mysql> use mysql Database changed mysql> show tables \G *************************** 1. row *************************** Tables_in_mysql: columns_priv *************************** 2. row *************************** Tables_in_mysql: db *************************** 3. row *************************** Tables_in_mysql: host *************************** 4. row *************************** Tables_in_mysql: tables_priv *************************** 5. row *************************** Tables_in_mysql: user 5 rows in set (0.02 sec) > Are there any commands you can use to locate the number / Names of > the tables ?? SHOW TABLES is the correct command... to get the number of rows: $num_rows = mysql_num_rows($result); <URL: http://www.php.net/manual/en/function.mysql-num-rows.php > > Ive uploaded my new script :- > > http://homepages.slingshot.co.nz/~gordon52/4.txt > > Which lists the databases available - You then click on the database > name you want, & it should list all the tables within the database > selected.. > > I had it showing the number of tables - Except where it should say the > table name it just said "array". Try using 0 (zero) instead of "Database"... > 1) How do i find the table names within a database.... SHOW TABLES > 2) Are there any step-by-step guides to PHP / MySQL - without skipping > over steps... This one looks promising... <URL: http://www.devshed.com/Server_Side/PHP/DB_Basics/page1.html > There are many other PHP and MySQL articles on devshed... this one is on normalization, and it starts with the basics...: <URL: http://www.devshed.com/Server_Side/MySQL/Normal/Normal1/page1.html > A MySQL introduction (a bit old, but it works): <URL: http://www.devshed.com/Server_Side/MySQL/Intro/page1.html > This is about implementing a PHP/MySQL application: <URL: http://www.devshed.com/Server_Side/MySQL/PerfectJob/PerfectJob1/page1.html > The MySQL tutorials page: <URL: http://www.mysql.com/portal/development/html/development-61-1.html > The official MySQL tutorial (chapter 3 of the manual): <URL: http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html > The zend tutorial page: <URL: http://www.zend.com/zend/tut/ > Some more PHP/MySQL tutorials: <URL: http://www.blazonry.com/scripting/linksdb/index.php > <URL: http://www.dynamicwebdevelopers.com/tutorials/?Mode=Browse&CatID=8 > <URL: http://www.zend.com/zend/tut/tutorial-yank.php > <URL: http://www.phpbuilder.com/columns/banahan20010720.php3?page=1 > Parts of the book "Build Your Own Database Driven Website Using PHP & MySQL" is available here: <URL: http://www.wdvl.com/Authoring/DB/SQL/Build/index.html > Finally, the 'official' unofficial MySQL FAQ pages: <URL: http://www.bitbybit.dk/mysqlfaq/ > -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
