I have two tables, i-e
SELECT `HID`, `HName`, `HDescription`, `ParentID`, `Latitude`, `Longitude`, `CatagoryType`, `Date` FROM `hazara_tbl`
SELECT HPhoto_ID, HID, Image, Date FROM hazara_tbl_photos
SELECT h.HID, h.HName, hp.Image from hazara_tbl h join hazara_tbl_photos hp on hp.HID = h.HID WHERE hp.HID = 49
You need aggregation. In MySQL, the typical function to use is
select h.HID, h.HName, group_concat(hp.Image) as images from hazara_tbl h join hazara_tbl_photos hp on hp.HID = h.HID where h.HID = 49 group by h.HID, h.HName;
The above assumed that
hp.image is a native SQL type. If it is a BLOB, then it is better for you to combine the results in the application layer. MySQL does not readily support arrays of BLOBs.