trying to connect to mysql with php

[davaddavad]

How do i add the show table command to this script? I hope it is ok to show this script if not mod delete it please. I just got php installed by my host and mysql. I dont have phpmyadmin or a mysql window. The only way I can connect is thru php. My host gave me the first half of the php page below. I added the select and create table from another script i found. I believe it built the table but I havent found the correct script to show the table to me. any help appreciated Dave


<?
$host=&quot;**********&quot;;
$dbase=&quot;********&quot;;
$login=&quot;********&quot;;
$passwd=&quot;********&quot;;
$cnx = mysql_connect($host,$login,$passwd);
if (!$cnx) {
print &quot;Error Connecting to MySQL server\n<BR>&quot;;
exit(0);
}
else {
mysql_select_db($dbase) or die(&quot;Error changing Database&quot;
print &quot;Connected to database!\n<BR>&quot;;
}
@mysql_select_db($dbase) or die( &quot;Unable to select database&quot;
$query=&quot;CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))&quot;;
mysql_query($query);
$query=&quot;SELECT * FROM contacts&quot;;
$result=mysql_query($query);
mysql_close();
?>

 

[sleipnir214]

To MySQL, SHOW TABLES is just another SQL query. Use it in place of one of the queries in the code snippet. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[davaddavad]

$query=&quot;SHOW TABLE&quot;;
I added this line although i didnt get an error it didnt show any tables either

 

[sleipnir214]

You must connect to the server, issue a query, fetch the results of that query, and output the fetched results.

You have the first two, possibly the third, definately not the last.

Take a look at the example code here:

http://www.php.net/manual/en/function.mysql-fetch-array.php

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[davaddavad]

Thanks for your time. Well now i have an understanding of the 4 steps I will try to get the fetch and the output to work.