Can anyone please help me write this using active records? |
[eluser]behnampmdg3[/eluser]
Hello; I am trying to use active records on this but I need a little bit of help. Thank you. Code: SELECT *, Code: $this->db->select('*, sincity_events.id AS EID, GROUP_CONCAT(sincity_events_celebrities.id) as CELEBS, , GROUP_CONCAT(sincity_celebrities.name) as CELEB_NAME');
[eluser]pisio[/eluser]
Yo ! When you have long query like this is better to use $this->db->query( " YOUR_LONG_QUERY " ); Active Records is not optimal solution for every think. Now with AR you make this query and after 1 year you shout to edit it, you will have problems. At last project I do I make this query : http://sphotos-f.ak.fbcdn.net/hphotos-ak...6128_n.jpg So think again is good idea to use AR or just query
[eluser]behnampmdg3[/eluser]
[quote author="pisio" date="1358078708"]Yo ! Now with AR you make this query and after 1 year you shout to edit it, you will have problems. [/quote]What? Why should I edit it after 1 year????
[eluser]Otemu[/eluser]
There isn't any difference between LEFT JOIN and LEFT OUTER JOIN |
Welcome Guest, Not a member yet? Register Sign In |