>> You seem to be mimicking the prepared query feature of mysqli in PHP5.
Do you
>> have the mysqli extension available? If so, you can use things like:
>>
>> http://www.php.net/manual/en/function.mysqli-stmt-bind-param.php
>>
>> which has an example as to how to utilize a prepared query.
>>
>>
Chris White wrote:
On Monday 27 November 2006 09:12, Filipe Freitas wrote:
CREATE PROCEDURE `getListaDeNewsflashes`(in quantidade smallint)
COMMENT 'Devolve uma tabela com um número limite de newsflashes'
begin
PREPARE statement FROM "SELECT * FROM newsflashes ORDER BY RAND() LIMIT ?";
SE
On Monday 27 November 2006 09:12, Filipe Freitas wrote:
> CREATE PROCEDURE `getListaDeNewsflashes`(in quantidade smallint)
>COMMENT 'Devolve uma tabela com um número limite de newsflashes'
> begin
> PREPARE statement FROM "SELECT * FROM newsflashes ORDER BY RAND() LIMIT ?";
> SET @limit=quanti
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 d
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.
What is happening when you make the call? That might help get some more
precise advice.
M
Chris White wrote:
On Monday 27 November 2006 07:59, 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
No success how? General
On Monday 27 November 2006 07:59, 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
No success how? Generally with stored proc
Remove the Semicolon
mysql_query("CALL mySP()");
Give it a try !!!
- Original Message -
From: Filipe Freitas <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Monday, November 27, 2006 10:59:09 AM GMT-0500 US/Eastern
Subject: Calling Stored Procedures from PHP
Hi
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
