Multiple MySQLi queries - Codeigniter

[eluser]1cookie[/eluser]
Hi, multiple query advice:

In CI, I would love to use:

Code:

$query  = "SELECT CURRENT_USER();";
$query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";

/* execute multi query */
if ($mysqli->multi_query($query)

I've seen something dating back to 2011: http://stackoverflow.com/questions/40591...odeigniter

What's changed? Anything.

What's my best bet? Transactions maybe:


http://ellislab.com/codeigniter/user-gui...tions.html



advice...