Re: Query Analyzer For MySQL with PHP?

Use the mysql monitor, from shell : mysql -u username -p dbname That'll log you in, now run some queries : mysql>SELECT * FROM tablename; At this point everything is selected and displayed from table tablename. In otherwords, we can run and view SQL queries from this console, much like MySQL does it for PHP. Here are a couple tutorials that should help : MySQL Monitor Tutorial : http://www.mysql.com/doc/T/u/Tutorial.html MySQL Tutorial (demonstrates monitor) : http://www.devshed.com/Server_Side/MySQL/Intro/ Also, phpMyAdmin has a place to enter and view such queries via a form. phpMyAdmin : http://www.phpwizard.net/projects/phpMyAdmin/ Regards, Philip On Mon, 23 Apr 2001, Brandon Orther wrote: > Hello, > I recently took an ANSI SQL class to better familiarize my self with SQL in > general. In the class we used MSSQL SERVER 7 and to do queries we used the > Query Analyzer. Does anyone know of a PHP script that works like the Query > Analyzer so I can test Queries in a Browser? Like A Text Area where I can > put the query and a simple form that sends it to MySQL. > > Thanks, > Brandon > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >