Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. <?php
  2.  
  3. public function getStory($storyID) {
  4. return $this->db->query("SELECT * FROM #__stories WHERE storyID = '$storyID'");
  5. }
  6.  
  7. //variant A
  8. public function getStoryWithText($storyID) {
  9. return $this->db->query("SELECT * FROM #__stories s, #__stories_text st WHERE s.storyID = '$storyID' AND s.storyID = st.storyID");
  10. }
  11.  
  12. //variant B
  13. public function getStoryWithText($storyID) {
  14. $data["info"] = $this->getStory($storyID);
  15. $data["text"] = $this->db->query("SELECT * FROM #__stories_text st WHERE st.storyID = '$storyID'");
  16. return $data;
  17. }
  18.  
  19. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement