Hi there, Im a newbie...
Ive installed PHP/MySQL 2 nights ago & have been Surfing various websites re installing & setting up MySqld using CGi/Perl.. I can do most things online _ in a DOS window - But i want to do them online - PHP file / CGI.. I've been following the website of :- http://www.wdvl.com/Authoring/DB/SQL/Build/ And its the best ive seen - so far... Im up to this page :- http://www.wdvl.com/Authoring/DB/SQL/Build/build4-5.html & now i'm stuck - I need to know 2-3 more things that i can do WITHIN / USING Perl.. My coder (see below)... From the build4-5 web-page above, I'll assume that $result = @mysql_query("show databases"); would be the correct code to SHOW the databases available.. However its not going & the website doesnt have the 2 commands that i want to do.. Can someone advise me the commands to :- 1) View/List Databases / Tables 1A) Add / create a Database/Table (I'll assume you use the @mysql_query in some way. 2) Ive figured out what these mean - But are there others _ that do other things ? - A list of them ? @mysql_select_db @mysql_query mysql_fetch_array << Can someone explain why theres no @ sign - & a website that explains this further... Text of my script / Copy of script - below G. Auckland. ------------------------------- <?php // Connect to the database server $dbcnx = @mysql_connect("localhost", "root", "kpta2x"); if (!$dbcnx) { echo( "<p>Unable to connect to the " . "database server at this time.</p>" ); exit(); } // Request the text of all the jokes $result = @mysql_query("show databases"); if (!$result) { echo("<p>Error performing query: " . mysql_error() . "</p>"); exit(); } // Display the text of each joke in a paragraph while ( $row = mysql_fetch_array($result) ) { echo("<p>" . $row["JokeText"] . "</p>"); } ?> New Zealand websites :- Im giving away FREE banner ads :- http://n-zealand.hypermart.net/cgi-bin/mylinks/help.shtml#advertise --------------------------------------------------------------------- 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
