[SOLVED] Simple query help

[mrjonnytou]

I would like to sort the result from the following query in descending order:

 

//$sort is a the name of a table to sort by

public function sortActiveByColumn($sort)

    {

        $select = $this->select()->from($this)

                                ->where('completed LIKE ?', 0)

                                ->order($sort);

 

        return $this->fetchAll($select);

    }

 

I've tried:

      ->order('$sort, DESC');

----------------------------

      ->order($sort)

      ->desc;

----------------------------

...and other variations.

 

Any guidance would be helpful/appreciated as I'm not sure of the syntax.

 

Regards,

 

[jesushax]

try

 

ORDER BY $sort DESC

[mrjonnytou]

no go. As soon as I do that, I get a syntax error: (Unexpexted T_String)

[revraz]

Let's see that change.

 

no go. As soon as I do that, I get a syntax error: (Unexpexted T_String)

[mrjonnytou]

public function sortActiveByColumn($sort)

    {

        $select = $this->select()->from($this)

                                ->where('completed LIKE ?', 0)

                                ->order by $sort DESC;

 

        return $this->fetchAll($select);

    }

[mrjonnytou]

anyone...?

[mrjonnytou]

the code works fine when you replace the $sort with a string value but there seems to be a problem with $sort when it is enclosed within ' '. I.e. $sort isn't being recognised as a variable.

[revraz]

You can't enclose a variable in single quotes, did you try double quotes?

[mrjonnytou]

It Works! Thanks a lot.

 

I can't believe thats all it was. Much appreciated.

 

The working code:

 

public function sortActiveByColumn($sort)

    {

        $select = $this->select()->from($this)

                                ->where('completed LIKE ?', 0)

                                ->order("$sort desc");

        return $this->fetchAll($select);

    }

 

Regards,