[PHP] Returning a Recordset from a Funtion

2010-06-25 Thread David Stoltz
Hi Folks, Upon occasion, I have the need to hit our MS MSL database from our PHP/mySQL server. So I've created a function, but I'm not sure if you can return a recordset from a function. My code is below... In the calling page I code: ?php include('../includes/mssql.php');

Re: [PHP] Returning a Recordset from a Funtion

2010-06-25 Thread Richard Quadling
On 25 June 2010 14:55, David Stoltz dsto...@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

RE: [PHP] Returning a Recordset from a Funtion

2010-06-25 Thread David Stoltz
Quadling [mailto:rquadl...@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 dsto...@shh.org wrote: ?php include('../includes/mssql.php'); hitMSSQL(server

Re: [PHP] Returning a Recordset from a Funtion

2010-06-25 Thread Richard Quadling
); Thanks for the reply! -Original Message- From: Richard Quadling [mailto:rquadl...@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 dsto...@shh.org

Re: [PHP] Returning a Recordset from a Funtion

2010-06-25 Thread Andrew Ballard
On Fri, Jun 25, 2010 at 9:55 AM, David Stoltz dsto...@shh.org wrote: Hi Folks, Upon occasion, I have the need to hit our MS MSL database from our PHP/mySQL server. So I've created a function, but I'm not sure if you can return a recordset from a function. My code is below... In the

RE: [PHP] Returning a Recordset from a Funtion

2010-06-25 Thread David Stoltz
MSQL for me, so it's not used too often - we're now developing with mySQL. Thanks for the info. -Original Message- From: Andrew Ballard [mailto:aball...@gmail.com] Sent: Friday, June 25, 2010 10:38 AM To: David Stoltz Cc: php-general@lists.php.net Subject: Re: [PHP] Returning a Recordset