RE: [PHP] MS SQL / PHP

Hi Marek, Thanks for your reply. Tried that and got the following output: COM Object ( [0] => Resource id #3 ) COM Object ( [0] => Resource id #9 ) COM Object ( [0] => Resource id #15 ) COM Object ( [0] => Resource id #21 ) There are 4 records in the table at the moment, and its performing the loop etc for the recordset but just isn't returning the data (or returning data in a readable format). Thanks Enda -- -----Original Message----- From: Marek Kilimajer [mailto:kilimajer@webglobe.sk] Sent: 27 January 2004 14:05 To: Enda Nagle Cc: PHP List Subject: Re: [PHP] MS SQL / PHP try print_r($Msku) and see what comes out Enda Nagle wrote: > I have a potentially stupid problem with PHP and MSSQL on a Windows > server... > > I can connect to the database and insert data to the tables etc but cannot > retrieve data... > > This is the code I'm using: > > //----------------------------------------------- > $list2 = $conn->Execute("SELECT * FROM elive.registration") or > DIE($conn->ErrorMsg()); > > while (!$list2->EOF){ > > $Msku = $list2->Fields("sku"); > $Mname = $list2->Fields("name"); > $Memailaddress = $list2->Fields("emailadd"); > $Mcountry = $list2->Fields("country"); > $Mnumdevices = $list2->Fields("numdevices"); > $Msource = $list2->Fields("source"); > > echo > "<tr><td>$Msku</td><td>$Mname</td><td>$Memailaddress</td><td>$Mcountry</td>< > td>$Mnumdevices</td><td>$Msource</td></tr>"; > $list2->MoveNext(); > } > //----------------------------------------------- > > The returned info is: > > Object Object Object Object Object Object > > Am I doing something stupid? > > Presumably, the code is the same as I am already using on an adodb > connection on a Linux box to a MySQL server? > > Thanks for the help > > Enda > Enda Nagle > +353 86 168 0774 > enda@nightsol.net > www.nightsol.net > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php