PHP MySQL - Stored procedure with a Query SOLVED

1st Time in almost 19 years i tried this a I was building backend intensive application using PHP & MySQL, where I had to reuse queries in many pages and had to write SQL QUERY repetitively almost everywhere across tables ****** mysqli PROCEDURE ******* DELIMITER // CREATE PROCEDURE prop_detail(IN pno INT) BEGIN SELECT * FROM listings, property_tbl WHERE listings.pno = pno and listings.pno = property_tbl.pno; END // DELIMITER; ***** PHP MYSQL *********** <?php include('config.php'); ?> <?php $mtk = mysqli_query($con,'CALL photo_all("184")') or die('photo error : ' . mysqli_error($con)); while($stk = mysqli_fetch_assoc($mtk)){ echo '<img src="' . $stk["location"] . '"><br>'; } ?>

LIFE COULD HAVE BEEN THIS SIMPLE BEFORE had i used it.

SHIT HAPPENS!!!!