2

I have created an stored procedure in mysql workbench. I am trying to call it with in php and I get the following error:

Warning: mysql_query() expects parameter 1 to be string, resource given in 
C:\xampp\htdocs\Project1\storedProcedure1.php on line 9

$res = mysql_query($connection, "CALL getPlayers1()") or  
  die("Query fail to launch:".mysql_error());

Any advice please?

By the way my stored procedure is the following:

DELIMITER $$
    CREATE PROCEDURE GetPLayers()
    begin
    select player_id, name, gender, playing_career,dob,place_of_birth
    from players;
    end $$
VMAtm
  • 27,943
  • 17
  • 79
  • 125
Alexander
  • 599
  • 2
  • 14
  • 25

0 Answers0