[RESOLVED] assign the value of a recordset row to a var

[tamayo]

Hi, I'm trying to assign the value of a specific row to a var, the code is:

$rsdepall=mysqli_query($conn, $sql) or die(mysqli_error($conn));
$xbandera=$rsdepall['depto'];

But I got the next error:
[

Fatal error: Cannot use object of type mysqli_result as array

my question is, what is the right way to pass the value of the row 'depto' to the $xbandera var?

regards

[bradgrafelman]

[man]mysqli_query/man doesn't retrieve any data from MySQL. You have to actually use a function that retrieves data, such as [man]mysqli_fetch_assoc/man.

[tamayo]

thanks, the work code is:
$xrs01=mysqli_fetch_assoc($rsdepall);
$xbandera=$xrs01['depto'];

Thanks a lot