change bin directory

[Mushonov]

hi,
im trying to open a .mdb file in my .php.

the problem is that im getting "unable to locate file ..." error, and the path points to some "xxx\bin\" directory.
how can i change the configuration so it'll point to my source directory (or to something else for this matter)? 😕

Thanks in advance,
Avi.
(this is my first post on php so be cautios 😉 )

[devinemke]

Avi Laviad wrote:

im trying to open a .mdb file in my .php.

how? as in, let's see the code.

[Mushonov]

the code is more general then about the specific code:

function GetDownloads()
	{
	 	$db = 'd:\\my projects\\xxx\\source\\db.mdb';

  	$conn = odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . $db, "", "");

	try
	{
		$sql =	'SELECT item_id FROM downloads;';

		$rs = odbc_exec($conn,$sql);

		$downloads = odbc_num_rows($rs);			

		odbc_errormsg();

		odbc_free_result($rs);
		odbc_close($conn);

		return $downloads;

	}
	catch (Exception $e)
	{
		echo $e->getMessage();
	}

i don't want to write 'd:\my projects\xxx\source\db.mdb', i want to write only db.mdb, so for that i need to change the runtime/output directory... isn't it?
how can i?