Stored Procedure variable question

Discussion in 'Programming' started by shadow007, Sep 5, 2011.

0
  1. #1
    Hi I am currently chnaging my code to accomdate stored procedures. I am using a mysql database and have set the stored procedure.
    The trouble I am having is this.
    My old code SELECT * FROM Client WHERE ID='$ID' works fine. (The variable used is a session based variable) However I am not sure how to accomodate the variable into a stored procedure.

    This is my stored procedure:

    CREATE PROCEDURE Identifier()
    SELECT * FROM Client WHERE ID='$ID';

    This dosent work and displays no data like what my previous code did.

    Would appreciate any help, thanks
     
    shadow007, Sep 5, 2011 IP