Jump to content
Larry Ullman's Book Forums
Sign in to follow this  
daddytiger

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...