is call procedurename() is work in
php version:5.2.4
mysql:5.0.45
server version:5.0.27

Recommended Answers

All 3 Replies

Try to ask an understandable question; then you will likely get an helpful answer.

is the call function in mysql is work in:php version:5.2.4
mysql:5.0.45
server version:5.0.27

If your question is whether you can use the "CALL" statement in PHP against an MySQL server, the answer is YES. The version of your MySQL client is irrelevant.
You can test it with

delimiter //
create procedure t()
begin
  update a set x = 1;
end
//
delimiter ;

drop table if exists a;
create table a (x integer default 0);
insert into a values (0);

and the php program

<?php
require_once('db.php');
mysql_connect( MYSQL_HOST, MYSQL_USER, MYSQL_PWD );
mysql_select_db( MYSQL_DATABASE );
mysql_query( 'update a set x = 0' );
mysql_query( 'call t' );

Result

select * from a;
+---+
| x |
+---+
| 1 |
+---+
1 row in set

So I wonder why you don't just try.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.