MIN - MAX DB Query

Hi

You can try to use the code below(PHP code)

$db = JFactory::getDbo();
$query = $db->getQuery(true)
->select('MAX(membership_id) AS max_membership_id')
->select('MIN(membership_id) AS min_membership_id')
->from('#__osmembership_subscribers');
$db->setQuery($query);
$row = $db->loadObject();

echo $row->max_membership_id;
echo $row->min_membership_id;


If it's SQL, just use SELECT MAX(membership_id), MIN(membership_id) FROM #__osmembership_subscribers

(#__osmembership_subscribers needs to be replaced with correct table name, depends on database prefix on your site)

Tuan

Thanks so much Tuan... Worked perfectly ... Michael

Hi Tuan,
I have a slightly tricker one this time.
Is it possible to create a button that exports a .xlsx spreadsheet of all member numbers between min and max that are not used??
Kind regards,
Michael

Hi Michael

It's unfortunately, this is not something we can guide you. For this, you will have to hire a developer to write code to develop that feature for you. It's not something quick and easy which we can guide you

Tuan