Jump to content

Archived

This topic is now archived and is closed to further replies.

zeus68

How to handle sql errors?

Recommended Posts

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?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.