How to retrieve from MySQL database more than one line?

where is the code?

Write SELECT * FROM `TABLE'WHERE `Something` LIKE 12;
The query must return all rows where something is equal to 12. And read W3C on how to use the design Like in different DBMS.

Allowance to overcome the problems of "nothing works":
1) Break the task into steps(first large, then smaller if you want)
in your case it is 1) a query that "should"(no) to select multiple rows. Go to the console or to phpMyAdmin and it prescribes the query directly. If the query returns 1 record - come learn the SQL syntax.
2) If the problem is not in the query - there is Vardan to output from a function that works with the database, you may not be using what is necessary, go to read about your database adapter and functions of it.
3) the object is - how and what happens here is a mystery, check that you feed input, see where the lost data in the course of the algorithm to get the output.
Hint: var_dump(), print_r();

It looks like you overwrite the array elements. Give the code where you transform the object into an array most likely it an error