Jump to content
Larry Ullman's Book Forums

Phpmyadmin Users Only? Ex2: Type = Coffee Or Goodies


Recommended Posts

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

 Share

×
×
  • Create New...