I am having problems using stored procedures. Making call to a stored procedure is not working for me. So I replaced the stored procedure by an sql statement. But now, I have some stored procedures which receive parameters. for example\[code\]CREATE PROCEDURE get_category_details_proc(IN incat_id INT)BEGIN SELECT name, desc FROM categoryWHERE cat_id = incat_id;END\[/code\]How can I replace this by using simply sql statements?Please see my previous question for more details.I already have this function in my database connection class:\[code\]public static function GetRow($sqlQuery, $params = null, $fetchStyle = PDO::FETCH_ASSOC) { $result = null; try { $database_handler = self::GetHandler(); $statement_handler = $database_handler->prepare($sqlQuery); $statement_handler->execute($params); $result = $statement_handler->fetch($fetchStyle); } catch(PDOException $e) { self::Close(); trigger_error($e->getMessage(), E_USER_ERROR); } return $result; }\[/code\]And in another class where I am actually calling the stored procedures I have:\[code\]public static function GetCategoryDetails($categoryID) { $sql = CALL get_category_details_proc
category_id); $params = array(':category_id' => $categoryID); return DatabaseHandler::GetRow($sql,$params); }\[/code\]
category_id); $params = array(':category_id' => $categoryID); return DatabaseHandler::GetRow($sql,$params); }\[/code\]