MySql w/ access

[Anon]

I have successfully installed and configured PHP w/ PWS and MySQL. I would now like to actually get working on something.

Heres the problem...i'm not very clear on how databases work on servers and stuff.

Using ASP you connect to a database using the path or DSN created in Control Panel under windows. This I thought I understood was always the same, but I can't relate PHP to ASP...?

If I have created a Acccess database on my client computer (*.mdb) and wish to use it while designing mysite it's easy ASP, but the same rules don't apply with mySql and PHP, or am I wrong...?

It's to my understanding that w/ PHP I would

1) Create a DSN under control panel...my file is testdb.mdb and the DSN is localhost.
2) I would then connect to the database using
<b>

$db = mysql_pconnect("localhost", "", "");
if(!$db){
echo "Error! Cannot connect";
exit; }

//What paramter would I use here?
//I thought the DSN was used in the above?
//Is this where I would select the database
//Would I not use the DSN...?
mysql_select_db("Unknown");

</b>

I'm doing something wrong, because my recordset isn't being filled with proper data and is causing a PHP error.

Someone please explain what these paramters are...?

Thanx!

[wchris]

$db_link = mysql_pconnect ($db_host, $db_user, $db_pass) or die ("Error! Cannot connect");

mysql_select_db ($db_name);

'$db_host' is the server where the dbase is, in your case 'localhost' should be right.
'$db_name' is the name of the dbase, for example 'testdbase'.