Search found 2 matches

by RegularKid
Wed Oct 14, 2009 9:09 pm
Forum: PHP - Code
Topic: Parsing Procedure Parameters Possible?
Replies: 1
Views: 117

Re: Parsing Procedure Parameters Possible?

Ok, got it solved :) A little messy, but it gets the job done:   // Build up stored procedure call and do error checking for parameter values $sql = "SELECT param_list FROM mysql.proc WHERE db = 'contraptionii' AND name = 'SaveChallenge';"; $res = $mysqli->query( $sql ); while( $row = $res...
by RegularKid
Wed Oct 14, 2009 7:20 pm
Forum: PHP - Code
Topic: Parsing Procedure Parameters Possible?
Replies: 1
Views: 117

Parsing Procedure Parameters Possible?

Hi! I've got a MySQL stored procedure and would like to get a list of it's parameter names and types. I'm able to get a single list of procedure parameters by doing the following MySQL SELECT:   $sql = "SELECT param_list FROM mysql.proc WHERE db = '" . $dbName . "' AND name = '" ...