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(DB_HOST.":".DB_PORT, 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($query)
or die("<br>KO: $query<br>" . mysql_error() . "<br>");
____________________________________

I get
____________________________________
PROCEDURE dedalo.sp_contattoWeb 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(mysql_error(), E_USER_ERROR);

On Jan 25, 10:20 am, "Mario Protto" <mario AT mario-online DOT
[e-mail]:

hi all,

PHP 4.3.10 and MySQL 5.0, trying

____________________________________
$link = mysql_connect(DB_HOST.":".DB_PORT, 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($query)
or die("<br>KO: $query<br>" . mysql_error() . "<br>");
____________________________________

I get
____________________________________
PROCEDURE dedalo.sp_contattoWeb 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(mysql_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(mysql_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_users.sourceforge.net>
The truth you speak has no past and no future.
It is, and that's all it needs to be.