Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- public function getStory($storyID) {
- return $this->db->query("SELECT * FROM #__stories WHERE storyID = '$storyID'");
- }
- //variant A
- public function getStoryWithText($storyID) {
- return $this->db->query("SELECT * FROM #__stories s, #__stories_text st WHERE s.storyID = '$storyID' AND s.storyID = st.storyID");
- }
- //variant B
- public function getStoryWithText($storyID) {
- $data["info"] = $this->getStory($storyID);
- $data["text"] = $this->db->query("SELECT * FROM #__stories_text st WHERE st.storyID = '$storyID'");
- return $data;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement