Re: [PHP] Calling PostgreSQL & MySQL Stored Procedures - SOLVED

2005-10-24 Thread Colin Shreffler
After further investigation I found that using the 'mysqli' object and corresponding extension library will allow you to execute MySQL stored procedures from PHP. documentation can be found at: http://www.php.net/manual/en/ref.mysqli.php cheers -c > On Sat, October 22, 2005 12:55 pm, Colin Shre

Re: [PHP] Calling PostgreSQL & MySQL Stored Procedures

2005-10-22 Thread Richard Lynch
On Sat, October 22, 2005 12:55 pm, Colin Shreffler wrote: > Can any one please tell me how you call a stored procedure in either > PostgreSQL or MySQL from php? WILD GUESS: $query = "call silly_sproc()"; mysql_query($query, $connection) or die(mysql_error($connection)); pg_exec($connection, $quer

Re: [PHP] Calling PostgreSQL & MySQL Stored Procedures

2005-10-22 Thread Colin Shreffler
One more caveat: With an without parameters would be very helpful. -c On 10/22/05 11:55 AM, "Colin Shreffler" <[EMAIL PROTECTED]> wrote: > Can any one please tell me how you call a stored procedure in either > PostgreSQL or MySQL from php? > > Cheers > -c Thank you, Colin Shreffler Principa

[PHP] Calling PostgreSQL & MySQL Stored Procedures

2005-10-22 Thread Colin Shreffler
Can any one please tell me how you call a stored procedure in either PostgreSQL or MySQL from php? Cheers -c