Get multiple but not all rows of MySQL DB in array

[StuntHacks]

Hey everybody,

I'd like to get some specific, but not all rows of a MySQL DB into an array, like those I get if I use mysql_fetch_array().
But feth_array, fetch_row, fetch_object, etc... just returns one row. There are many search functions in the internet, so it must be possible. I don't want to check every object in the table because it's pretty big and that takes a while.

~ StuntHacks

[pritaeas]

The fetch functions return one row of the result set, which is returned by a query you execute against that big table. Make the right query so the database server does all the hard work.

[Gideon_1]

I think provided your query is correct, use a while loop to output the rows like

$query = //this is your SQL statement;

while ($row = $query->fetch_object()) {
    echo $row->id, '<br>';
    echo $row->the name of your column you selected;
}