Re: 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