MS Access and selecting a autonumber

[ptbsG_Man]

I am having a hard time getting this to work all Im trng to do is Select the record with the ID i just added here is my code

<?
function dispaly_add ($id) {
	$id = (int) $id;
    $db_connection = new COM("ADODB.Connection");
    $db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("./ssatellite.mdb") . " ;DefaultDir=" . realpath("./");
    $db_connection->open($db_connstr);
	$rs = $db_connection->execute("SELECT * FROM Contracts WHERE id='$id'");
}
?>

now i keep getting the error

Warning: Invoke() failed: Exception occurred. Source: Microsoft OLE DB Provider for ODBC 
Drivers Description: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
criteria expression. in 
C:\home\systemservicecorp\form.php on line 159

line 159 is the SELECT line

any ideas on how to solve this or is there some differant way to select autonumbers kinda like if you select the date you use #date# is there sumthing like this for autonumbers?

Thanks in advance
Don

[barand]

If $id is int, it may not like the quotes. Try

$rs = $db_connection->execute("SELECT * FROM Contracts WHERE id=$id ");

[ptbsG_Man]

Thank you that was the problem. I always thought you had to have the ' ' around your data

[Pig]

MySQL is tolerant of quoted int's, but most db's aren't.