1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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