RE: [PHP] Returning a Recordset from a Funtion
| From: | David Stoltz | Date: | Fri, 25 Jun 2010 14:07:07 +0000 |
| Subject: | RE: [PHP] Returning a Recordset from a Funtion | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-306429@lists.php.net to get a copy of this message | ||
Tried that -
I finally got it - in the function I had to return the actual query execute, instead of the
recordset.
This did not work:
$rs = $conn->execute($query);
Return $rs;
This DID work:
Return $conn->execute($query);
Thanks for the reply!
-----Original Message-----
From: Richard Quadling [mailto:rquadling@gmail.com]
Sent: Friday, June 25, 2010 9:59 AM
To: David Stoltz
Cc: php-general@lists.php.net
Subject: Re: [PHP] Returning a Recordset from a Funtion
On 25 June 2010 14:55, David Stoltz <Dstoltz@shh.org> wrote:
> <?php
>
> include('../includes/mssql.php');
>
>
> hitMSSQL("server","database","username","password","SELECT
> * FROM
> TABLE1");
>
> echo $rs->Fields(1);
>
> ?>
You are not catching the result of the hitMSSQL() function.
Try ...
<?php
include('../includes/mssql.php');
$rs =
hitMSSQL("server","database","username","password","SELECT
* FROM
TABLE1");
echo $rs->Fields(1);
?>
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling