Joomla query pick value

Question

$user = JFactory::getUser();
$id = $user->get('id'); // or $user->get('id');
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select($db->quoteName('membership'))->from($db->quoteName('#__jomcl_adverts'))->where($db->quoteName('id')."=".$db->quote($id));

$db->setQuery($query);
$memb = $db->loadObjectList();

this is the result when I echo 'query'

SELECT `membership` FROM `#__jomcl_adverts` WHERE `id`='7221'

I am using Joomla, I want to pick the value in Membership column inside Adverts table.

I need the code to follow the if condition if the value inside membership is 5.

<?php if($memb['membership'] == "5") { ?>
<div id="jomclpstbtn<?php echo $module->id; ?>" class="jclasspstbtn <?php echo $params->get('moduleclass_sfx'); ?>">
<div class="jclasspstbtnblock">
    <a class="jomclbtnlink" > 

        <span class="jomclbtnname">Advert Already Posted</span>
    </a>
</div>
</div>

Just like this.

But I guess the query isn't picking value from Membership Column.

Answer 1

Basically loadObjectList() returns an indexed array of PHP objects from the table records.

so your if condition should be :

<?php if($memb['0']->membership == "5") { //for first set of result ?>

eg : $row['index']->membership // e.g. $row['2']->membership

you can read in more details here