Posted by petersprc on 01/27/07 04:19

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
c...@usaquelloprimadichiocciola.invalid> wrote:
> 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
> ________________________________

• Next in forum: Re: How do I resize an image to a given window size?
• Prev in forum: Re: convert XML feed array to assocative
• Thread view: Re: how to call stored procedure MySQL 5 from PHP4

[Reply to this message]