work with Prestashop database

[lolalola]

Hi,
how work with database?

get information for example from ps_country table, send, update...

$customer = Db::getInstance()->getRow('SELECT * FROM '._DB_PREFIX_.'gallery WHERE name = \''.pSQL($customerEmail).'\'');

Now i get one row, how get all values from this table?

Thanks

[MrBaseball34]

Try using

Db::getInstance()->ps('SELECT * FROM '._DB_PREFIX_.'gallery WHERE name = \''.pSQL($customerEmail).'\'');

Remember, this returns an array.