any help on calling stored procedure in php?

Discussion in 'MySQL' started by bartolay13, Nov 5, 2007.

  1. #1
    hello,
    i just want to ask how to call stored procedures in mysql to php script..
    thanks in advance.
     
    bartolay13, Nov 5, 2007 IP
  2. obsesif

    obsesif Peon

    Messages:
    74
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    SPs do need special permissions on server, which most shared providers do not give. I went to a VPS-account for my heavily SP-based project. Btw, check the MySQL version also.
    If all is fine you do a "CALL pName(x, y, z);" trough SQL...
     
    obsesif, Nov 6, 2007 IP