daddytiger Posted January 2, 2014 Share Posted January 2, 2014 Hi Larry and fellow forum users. I am new to stored procedures so... The stored procedures early in the coffee site were returning query results in the php scripts wonderfully, and in the mysql client. But the procedures using the variable "type" (as in coffee or goodies), e.g., select_categories, select_products, etc were returning empty sets in phpmyadmin directly (selecting Routines tab, Execute button). The variable "type" was not being recognized as an IN and so was apparently empty. Fixed using the Routines tab Edit button (filling in the form for the parameter). Must be because the phpmyadmin code is disallowing the variable "type" when a MYSQL attribute for fields is "Type"? (If we change type in the sql creating the procedure to type1 or type_of_stuff, for example, phpmyadmin picks it up as an IN parameter. Link to comment Share on other sites More sharing options...
Larry Posted January 8, 2014 Share Posted January 8, 2014 Thanks for sharing that and kudos for figuring it out! Link to comment Share on other sites More sharing options...
Recommended Posts