Newbie Q - controller/view code for mixed query

[eluser]osci[/eluser]

Without trying to sound boorish, when it comes to SQL, do you really know what you’re doing? Did you think of - and could you write - the query I posted as a solution?

That's what you think of?

I never tried to give a solution to the topic. I "hijacked" because I read Nick_MyShuitings's post and as I read the same in another of his recent posts I couldn't resist arguing about it. Sorry @vinofilus.

Also when you argued about the impossible since I've done it again before I just grabbed your code and showed you how I did it elsewhere (that should point a bit if I could)

Its good you know advanced sql (not just simple queries) and even better that you put your mind down and wrote the sql to help vinofilus. But isn't that enough? Do you want to brag? And if you wanted btw couldn't you do it without getting personal?

That's about the quote.

Why I do it with AR?

Because I like using such syntax. I like thinking of where add it, order by add it bla bla, that simple. I create most of my js in php code to use, for example

Code:

$this->js_lib->jquery_onload($this->js_lib->slidetoggle_element('#toggle_products', '500'));
$this->js_lib->admin_tinymce($lang);
$render['js_bottom']=$this->js_lib->export();

You could do it in a totally different way, right?
But I like this way of syntax and if I can keep it like this with little impact (as translating the real sql that I write by hand in paper, or coverting my js customizations to php) I just do so.

My only trouble about the above AR for now is that it's a _method and could change in future implementation. If I was given the option to have it as a normal method I'd be quite happy about it and could safely go.