orangerobot

Possible solution: I was having the exact same problem in Dreamweaver trying to connect to my GoDaddy mysql database.  The connection would work about one out of ten times.  I would often get the "***no tables found" error. But, once I got rid of GoDaddy and moved to a different provider (webhostfreaks.com) the problem completely disappeared.  Something is screwy with GoDaddy's database hosting.  I spent far too many hours trying to figure out this problem so I hope this saves someone else the time. -O.R.

What is the best route for me to put up my MS Access database and forms onto the web then? I don't mind rebuilding them into php/mysql but I don't want to make this harder than it has to be. -O.R.

Hi all, Can someone recommend a development tool for php/mysql? I can't seem to find anything out there that is WYSIWYG. Is there an industry standard? I've tried Dreamweaver MX 2004 but I wasn't that impressed. I'm moving some MS Access database and forms to the web and am used to the drag/drop ability (plus some coding in the background). Is there anything like this for php/mysql? Thanks, O.R.

Ok, that did it!!! Thanks! I also had to change my "localhost" to "mysqlxxx.secureserver.net" as specified at my godaddy hosting account. Why wouldn't localhost work since I'm running the php code on their local server?

Hi all, I'm new to php/mysql. I've made some headway but I can't get past this basic issue. I'm uploading the text below as "createtable.php" to my web space but it keeps returning, "Unable to select database". <? $user="<my_username>"; $password="<my_password>"; $database="<my_database>"; mysql_connect(localhost,$user,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="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))"; mysql_query($query); mysql_close(); ?> My phpinfo.php test file: <? phpinfo(); ?> returns all the PHP info including a section on mysql and my timetest.php file: <p>This page was created at < b> <?php echo date("h:i:s a", time()); ?> </ b> on the computer running PHP.</p> returns the current time as it should so I'm pretty sure my php and sql are up and running. But I can't figure out why I can't create a table ... it is maddening! Any help would be appreciated!! -OR