I am learning about stored routines and am having a hard time getting results. I have this in mysql:
DROP PROCEDURE `test`//
CREATE DEFINER=`user`@`localhost` PROCEDURE `test`()
SELECT * FROM `database`.`tablecds`;
How would I call on the results? I've tried the following and can't get an answer, so obviously I am doing it wrong.
$sql = "CALL test();" or die(mysql_error());
$sql = "SELECT @cd;";
$result = mysql_query($sql, $con);
$row = mysql_fetch_assoc($result);
Please enlighten me! Thank you in advance for any help!