Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. public function GetWikiPostArticle()
  2. {
  3.  
  4. $this->db->select('article.*,A.id as Aid,A.title as Atitle,A.shorttext as Ashorttext,A.full_text as Afull_text,A.picture as Apicture,A.auther as Aauther,A.date as Adate,A.view as Aview,A.liked as Aliked,A.level as Alevel,A.parent_article as Aparent_article,A.random as Arandom');
  5. $this->db->from('article as A');
  6. $this->db->join('article', 'A.id = article.parent_article');
  7.  
  8. $query = $this->db->get();
  9.  
  10. return $query;
  11. }
  12.  
  13. Error Number: 1054
  14.  
  15. Unknown column 'A.level' in 'field list'
  16.  
  17. SELECT `article`.*, `A`.`id` as `Aid`, `A`.`title` as `Atitle`, `A`.`shorttext` as `Ashorttext`, `A`.`full_text` as `Afull_text`, `A`.`picture` as `Apicture`, `A`.`auther` as `Aauther`, `A`.`date` as `Adate`, `A`.`view` as `Aview`, `A`.`liked` as `Aliked`, `A`.`level` as `Alevel`, `A`.`parent_article` as `Aparent_article`, `A`.`random` as `Arandom` FROM `article` as `A` JOIN `article` ON `A`.`id` = `article`.`parent_article`
  18.  
  19. Filename: models/M_cleint.php
  20.  
  21. Line Number: 38
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement