Welcome Guest, Not a member yet? Register   Sign In
MYSQL User Variables
#1

[eluser]Timothy_[/eluser]
Hello,

I am trying to set a variable within my sql query as I pack the results from the query into an array,

I have done a lot of reading, trial and error but still no luck

http://dev.mysql.com/doc/refman/5.0/en/u...ables.html

Code:
query = $this->db->query("    SET @a := 0;
                    SELECT @a, title.id, date as datedue
                    FROM lists
                    ");

I have also tried other variations, but all return Code Igniter MYSQL errors.

Any help is appreciated.

Tim


Messages In This Thread
MYSQL User Variables - by El Forum - 10-24-2009, 07:20 AM
MYSQL User Variables - by El Forum - 10-24-2009, 07:55 AM
MYSQL User Variables - by El Forum - 10-25-2009, 01:52 AM
MYSQL User Variables - by El Forum - 10-25-2009, 07:26 AM
MYSQL User Variables - by El Forum - 10-25-2009, 07:43 PM
MYSQL User Variables - by El Forum - 10-26-2009, 07:28 PM
MYSQL User Variables - by El Forum - 10-26-2009, 07:36 PM
MYSQL User Variables - by El Forum - 10-26-2009, 07:42 PM



Theme © iAndrew 2016 - Forum software by © MyBB