Re: [PHP] MS SQL / PHP

[Marek Kilimajer]

You need to find out what $list2->Fields("sku"); returns. This is not 
php anymore, check COM reference.

Enda Nagle wrote:

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:[EMAIL PROTECTED]
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
[EMAIL PROTECTED]
www.nightsol.net


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php