Search found 2 matches
- 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...
- 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 = '" ...