---

SELECT * FROM `pets` INNER JOIN `categories` ON `pets`.`category_id` = `categories`.`cat_id` WHERE `pets`.`id` = 1001 ;

---

Array ( [id] => 1001 [user_id] => 1 [category_id] => 1 [breed] => Siamese [dob] => 2023-01-01 [gender] => Male [original_price] => 450.00 [price] => 300.00 [microchip_number] => MICRO12345 [titlename] => Kitty [description] => Purebred Siamese Longhair (Balinese) Very Rare In Australia Cinnamon point 1 x boy Lilac Tabby point 1 x girl Vet checked, vaccinated, wormed, microchiped, desexed before leaving Parents both show champions Transport to Sydney on 11th April insterstate can be arranged interstate transport can also be arranged All my kittens are raised indoors and well socialized Last 2 pics are of dad [listed_date] => 2023-06-01 [city] => Coffs [mother_breed] => Siamese [father_breed] => Siamese [is_rescue] => 0 [featured_image] => kitty.jpg [status] => For Sale [images] => kitty.jpg,kitty2.jpg,kitty3.jpg [cat_id] => 1 [name] => Cats [active] => 1 )

---

Array ( [0] => kitty.jpg [1] => kitty2.jpg [2] => kitty3.jpg )