vea acosta yo le recomiendo asi
Código PHP:
//Conexion
$link = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
//Seleccionamos
mysql_select_db($database, $link);
$query = "SELECT * FROM activo where cantidad= '1' ";
$execute_query = mysql_query($query, $link) or die(mysql_error());
//Relacionamos los datos
$resultados_execute_query = mysql_fetch_assoc($execute_query);
//Contamos los resultados
$total_execute_query = mysql_num_rows($execute_query);
if ($total_execute_query == 0)
{
echo "<script>alert('No hay registros con stock minimo')</script>";
}
else
{
echo "<script>alert('Hay ".$total_execute_query." registros con stock minimo')</script>";
}
mysql_free_result($execute_query);