how to call stored procedure MySQL 5 from PHP4

[Mario Protto]

hi all,

PHP 4.3.10 and MySQL 5.0, trying

_______________ _______________ ______
$link = mysql_connect(D B_HOST.":".DB_P ORT, DB_USER, DB_PW)
or die("Could not connect:" . mysql_error());
mysql_select_db (DB)
or die("Could not connect:" . mysql_error());

$query = "call
sp_contattoWeb( '".$_SESSION['sess_kcliente']."','$kContatto ', '$cognome',
'$nome', '$posizione', '$telefono', '$cellulare', '$email','$note ', @out)";
$result = mysql_query($qu ery)
or die("<br>KO: $query<br>" . mysql_error() . "<br>");
_______________ _______________ ______

I get
_______________ _______________ ______
PROCEDURE dedalo.sp_conta ttoWeb can't return a result set in the given
context

_______________ _______________ ______

do I have to upgrade to PHP5, mysqli or is there another way to do that
without weak up my Linux admin ..:)?

thx
Mario
_______________ __________
WEB: www.mario-online.com
_______________ _______________ __

[petersprc]

Try setting client_flags to 65536 in mysql_connect, e.g.:

mysql_connect($ host, $user, $pass, false, 65536) or
trigger_error(m ysql_error(), E_USER_ERROR);

On Jan 25, 10:20 am, "Mario Protto" <mario AT mario-online DOT
c...@usaquellop rimadichiocciol a.invalidwrote:

hi all,

PHP 4.3.10 and MySQL 5.0, trying

_______________ _______________ ______
$link = mysql_connect(D B_HOST.":".DB_P ORT, DB_USER, DB_PW)
or die("Could not connect:" . mysql_error());
mysql_select_db (DB)
or die("Could not connect:" . mysql_error());

$query = "call
sp_contattoWeb( '".$_SESSION['sess_kcliente']."','$kContatto ', '$cognome',
'$nome', '$posizione', '$telefono', '$cellulare', '$email','$note ', @out)";
$result = mysql_query($qu ery)
or die("<br>KO: $query<br>" . mysql_error() . "<br>");
_______________ _______________ ______

I get
_______________ _______________ ______
PROCEDURE dedalo.sp_conta ttoWeb can't return a result set in the given
context

_______________ _______________ ______

do I have to upgrade to PHP5, mysqli or is there another way to do that
without weak up my Linux admin ..:)?

thx

Mario
_______________ __________
WEB:www.mario-online.com
_______________ _______________ __

[Mario Protto]

petersprc wrote:

Try setting client_flags to 65536 in mysql_connect, e.g.:

mysql_connect($ host, $user, $pass, false, 65536) or
trigger_error(m ysql_error(), E_USER_ERROR);

thx Peter, I've already tried it but it seems there is no way, anyone has
experience about that?

Mario

_______________ _______________ __
WEB: www.mario-online.com
_______________ _______________ __

[Bruno Barberi Gnecco]

Mario Protto wrote:

petersprc wrote:

>>Try setting client_flags to 65536 in mysql_connect, e.g.:

mysql_connect($ host, $user, $pass, false, 65536) or
trigger_error(m ysql_error(), E_USER_ERROR);

thx Peter, I've already tried it but it seems there is no way, anyone has
experience about that?

Mario

_______________ _______________ __
WEB: www.mario-online.com
_______________ _______________ __

I made two changes that solved the problem for me:

* stopped using persistent connections
* used 131074 as client_flags.

--
Bruno Barberi Gnecco <brunobg_at_use rs.sourceforge. net>
The truth you speak has no past and no future.
It is, and that's all it needs to be.