How to handle sql errors?

[zeus68]

I use this code to connect to my access database that's sat on a XP machine (no sql server) it's a dsn-less connection

<?

$conn = new COM("ADODB.Connection") or die("Cannot start ADO");

$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=dvd.mdb");

 

//$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db");

$rs = $conn->Execute("SELECT * FROM dvd WHERE title LIKE '%$title%' ORDER BY title");

?>

 

I need to display something like "no movies found" if the search aql query returns no fields.

 

For some reason some of the sql statements don't seem to work. i.e. if I add above to the sql query the TOP 10 next to the select statement it works fine but if I also add START 10,10 doesn't

 

Any ideas?