Welcome Guest, Not a member yet? Register   Sign In
SOLVED : Active Record DB Query Question
#1

[eluser]Unknown[/eluser]
*Love creating a post then figuring it out a half hour after.

I have been able to do the basics with the active record db structure. I am starting to need a little more out of the queries.

If I am doing a update and the query I want needs to do this:

Code:
mysql_query("UPDATE table_name SET column_name_1 = CASE id
            ".join($vals)."
            ELSE column_name_1
            END");

Can I build that with $this->db->update() somehow?

Thanks for any help you can provide.




Theme © iAndrew 2016 - Forum software by © MyBB