Skip to content

Instantly share code, notes, and snippets.

@alexbowers-tecmark
Created March 20, 2015 13:33
Show Gist options
  • Save alexbowers-tecmark/bf4102dc5cf55947d689 to your computer and use it in GitHub Desktop.
Save alexbowers-tecmark/bf4102dc5cf55947d689 to your computer and use it in GitHub Desktop.
Working response
Array
(
[1] => Array
(
[id] => 1
[name] => Colour
)
[3] => Array
(
[id] => 3
[name] => Weight
)
[4] => Array
(
[id] => 4
[name] => Size
)
[5] => Array
(
[id] => 5
[name] => type
)
[2] => Array
(
[id] => 2
[name] => Simple Colour
)
)
@alexbowers-tecmark
Copy link
Author

Here is the generated SQL:

SELECT `Attributes`.`id`, `Attributes`.`name` FROM `attributes` AS `Attributes` WHERE `Attributes`.`deleted` = 0 ORDER BY `Attributes`.`order_num` ASC LIMIT 10;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment