New databases with PHP/MySQL

Report · Oct 19, 2009

Hi,

I know how to interact with a database using PHP/MySQl thanks to this tutorial (http://www.adobe.com/devnet/dreamweaver/articles/first_dynamic_site_pt3_03.html), but now that I tried to create my new database on phpmyadmin, I can't log in when I test it on my testing server. Is there an easy answer, or maybe a tutorial series that will help me learn how to create a new database and interact with it? I always get this error when I test:

Warning: mysql_select_db(): supplied resource is not a valid MySQL-Link resource in (my folder) on Line (so and so)

Any help would be appreciated, but I am not very familiar with either language in terms of coding.

Thank you!!!

Report · Oct 22, 2009

not to state the obvious, but did you start your mysql server before attempting to connect to it? Did you use the default user/pass? Is this your first login?

I would recommend downloading the free mysql gui tools available from the mysql website. they are an excellent way to interface with your mysql server/database. Also consider Navicat, which is a very easy to use tool as well.