Jump to content

zeus68

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

zeus68's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I use php to connect to an access mdb database in windows XP how do I get to count all the output records from a select statement? I used count(*) but doesnt work
  2. 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?
×
×
  • Create New...

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.