Que tal, de aquí obtengo "Maximo"
Código PHP:
SELECT max(provider_call_log.provider_call_log_id)
AS Maximo, provider_call_log.status_2, provider.provider_id,
provider.company_name, provider.country,
provider.medical_speciality
FROM provider_call_log
RIGHT JOIN provider ON
provider_call_log.provider_id = provider.provider_id
Y aquí lo anterior
Código PHP:
<?php
$var = $row_Recordset1['Maximo'];
$maximostatus = mysql_query("SELECT status_2
FROM provider_call_log WHERE provider_call_log_id = $var ");
echo $maximostatus
?>