Hi Nadine,
Turn on debugging. Eg.
$db = ADONewConnection('access');
$db->debug = 1;
"-* Nadine *-" <smittenwithsmirnoff@xxxxxxxxxxx> wrote in message
news:BAY1-F70bQI9hGLdsJH000096ca@xxxxxxxxxxxxxx
> Hi
> I'm a new member to the list and using php of rthe first time. I have
> decided to use adodb so I can make a dsn-less connection to an access
> database.
> I have managed to get my script to run without errors but thats all....
I've
> tried using a Select statement but it does nothing...
> here's my code:
>
> <?php
>
> include("adodb/adodb.inc.php"); // includes the adodb library
> $db = ADONewConnection('access');
> $dsn = "Driver={Microsoft Access Driver
>
(*.mdb)};Dbq=http://student.dcu.ie/Project/XtraVision.mdb;Uid=Admin;Pwd=;";;
> $db->Connect($dsn);
>
> $sql = "SELECT Surname, City FROM Member";
> $rs = &$db->Execute($sql);
> if (!$rs)
> {
> echo $db->ErrorMsg(); // Displays the error message if no results could be
> returned
> }
> else
> {
> while (!$rs->EOF)
> {
> echo $rs->fields[0].' '.$rs->fields[1].'<BR>'; // fields[0] is surname,
> fields[1] is age
> $rs->MoveNext(); // Moves to the next row
> } // end while
> } // end else
>
>
>
> ?>
>
> Thanx in advance :)
>
> _________________________________________________________________
> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> http://join.msn.com/?page=features/virus
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
