Create an array inside a select query?

[onedumbcoder]

Ok lets say I have a table named box, and the box table has the following fields:

 

apple, orange, screw, nut, pen, shoe, lock.

 

 

How do I capture those as an array? SOmething like this

 

"SELECT tablearray = array(apple, orange, screw, nut, pen, shoe, lock) from box"

 

 

[BLaZuRE]

It returns an array by default ... just do

SELECT * FROM table_name

You'll have to loop though to return each one of the rows.

[onedumbcoder]

I know that, I want one of the elements returned to be an array.

[Bjom]

there is no array data type in sql. you get an array per row in php easily when using the standard querying methods (mysqli or mysql).