Filipe Freitas wrote:
Hi,
This is not a mysql thing but maybe you can help me.
I want to call a stored procedure from PHP, so I tried it like normal
querys: mysql_query("CALL mySP();"); with no success.
thx
I'm not PHP expert but I've managed to do this in perl using DBI (in
spite of all docs saying there are no such thing as OUT params). Perhaps
you could try s.th. alike:
# perl DBI with firebird: stored proc has 3 IN and 4 OUT params as you
can see...
my $s = "SELECT field1, field2, field3, CAST(field4 AS VARCHAR(32))".
" FROM S_GET_NAL_WEB('12-31-05', 4201, '2051600')";
my $sth = $dbh->prepare($s) or die $dbh->errstr();
$sth->execute() or die $sth->errstr();
while (@data = $sth->fetchrow_array()) {
print join("<BR>", @data)."<BR><BR>";
}
...
HTH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
