Do you have a fully working Table in your Database. And also show us the code in which you are connecting to the Database with.
Then you can do something like this.
I hope this is what your looking for but also just check your information in PHPMyAdmin.
mysql_pconnect("Host Name Here","Username Here","Password Here");
mysql_select_db("database Name Here");
$result = mysql_query("select * from `Table name`");
$field1 = $r["field Name"];