Database connects but no tables are shown
Hello
I have connected to the database on my remote server in dreamweaver 8 and it says its connected successfully, but when I open the tree or try to make a recordset no tables are show and when I try it in advanced this error appears:
"Error calling GetTables:
MySQL Error#: 1064
You have an error in your SQL syntax; check the manual that
correponds to you MySQL server version for the right syntax to use
near '-maillist' at line1"
maillist being my database name
I'm not very good at dynamics yet so don't really understand the SQL syntax
This is what dreamweaver connection made me:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_blog = "localhost";
$database_blog = "servername"
$username_blog ="servername"
$password_blog ="password"
$blog = mysql_pconnect ($hostname_blog, $username_blog, $password_blog or trigger_error (mysql_error (), E_USER_ERROR);
?>
Don't know if any of this makes sence to you.
Please Help!
