Why can't i connect to mysql?

You appear to have a couple of different, albeit related problems.

One problem appears to be that you're trying to access your remote database within Dreamweaver. Most hosting companies prevent remote access to a database for security reasons. Although you can use a remote database as your testing server, it's not recommended.

The other problem is that when you click the Search button in your donations_2.php page, you get the message "No database selected". That indicates that the file in the Connections folder doesn't have the correct database details. The connection script (in the Connections folder) should contain something like this:

$hostname_connAdmin = "localhost";

$database_connAdmin = "mydatabase";

$username_connAdmin = "admin";

$password_connAdmin = "secret";

On most hosting companies, "localhost" is the correct value for hostname. You need to check that the name of the database is correct.

Setting up this type of connection can be difficult if you don't have experience with PHP/MySQL. The best way to do it is to use the same setup locally as on your remote server. For example, give your local version of the database the same name and structure as the remote version. Also use the same username and password.

You should also be aware that Dreamweaver's server behaviors are being withdrawn because they use outdated code that will eventually stop working. You're safe for the time being, but you will eventually need to replace the PHP code generated by Dreamweaver with more up-to-date code.